"The Result is not a valid number" when trying to Calculate Price per square foot

Follow

Michael Laniak

• February 08, 2016 00:00

 

Calculation field below:

@Seller's Price / @Property Size (Sq. Ft.)

 

@Seller's Price is a currency value
@Property Size (Sq. Ft.) is a number

But errors out with "The result is not a valid number?

Do I have to put javascript into the calculation field to convert the value type.

0

• 

  Hamid

  • February 08, 2016 12:41

  Hi Mickael,

  create a new calculation field and retry 

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 08, 2016 13:32

  hi Michael,

  sometimes you have to "persuade" the calculation field ot accept something. Try

  (@Seller's Price / @Property Size (Sq. Ft.)) || 123 

  Is @Property Size (Sq. Ft.) a number field or a number in a text field?

  Rainer

   

   

  0

  Comment actions Permalink
• 

  Michael Laniak

  • February 09, 2016 15:54

  Thank you for offering the help but it still is not working. Here are the field types.

  1). @Seller's Price = (Money Field)
  2). @Property Size Sqft. = (Number Field)

  

  I would like to find a solution where the field types stay as they are and not switching the @Seller's Price field to a number if possible.

  0

  Comment actions Permalink
• 

  Hamid

  • February 10, 2016 13:39

   

  "$" + (@Seller's Price / @Property Size (Sq. Ft.)).toFixed(2) || 123 

   

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 10, 2016 15:51

  "Not a valid number" can also appear if the factor (your number field) is empty. 

  @Property Size Sqft. != null ? @Seller's Price /@Property Size Sqft. : ""

  If number field has no value it doesn't run the calculation and shows nothing in the calc field. 

  Rainer

  1

  Comment actions Permalink
• 

  Michael Laniak

  • February 11, 2016 16:10

  Rainer thank you!  That was the issue.  And now it shows properly in the calculation field for.  :-)

  @Property Size SqFt. != null ? @Seller's Price /@Property Size SqFt. : ""

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.