Error in calculated fields


I have two fields I would like to add which would be calculated from values in other fields.

None of the other fields are calculated fields themselves - just imported data points.

I think I have my formulas correct. One involves multiplying data from two fields (yes, I’m using *); the other involves dividing one field by another.

In both cases, I just get #ERROR! in the field.

I’ve checked to see that the fields are fully populated, which they are.

Why do I keep getting these Error messages?



I think I solved it myself. Changed the data field types from text to number and the errors disappeared.!!


1 Like