Hi! I thought a simple formula shown below would calculate price per square foot for my table.
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.