Help

Price per Square Foot

Topic Labels: Formulas
639 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Admin_LI
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi! I thought a simple formula shown below would calculate price per square foot for my table.

 

{Price} / {Building SqFt}
 
Both Price and BuildingSqFt are columns in my table, so I am not sure why the formula gives me an ERROR response. What formula do I need instead?
 
Thank you!
2 Replies 2

Can you post a screenshot that shows the field types? I’m guessing that at least one of those fields is not a number field, even if it looks like a number. 

Shawn_Peters
6 - Interface Innovator
6 - Interface Innovator

1-Ensure values exist for the sqft as dividing by zero is not viable,  but can be bypassed wrapping the formula in an if statement IF ({Building SqFt},{Price} / {Building SqFt}) .

It may also be a matter of declaring the values to be float or int type prior to calculation 

 

-Shawn
慄Time Wizard