Re: Price per Square Foot

249 0
Showing results for 
Search instead for 
Did you mean: 
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. 

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 


慄Time Wizard