Skip to main content

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?


Thanks

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


Whew!!!


Reply