Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Error in calculated fields

1094 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron_Jamieson
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Ron_Jamieson
4 - Data Explorer
4 - Data Explorer

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

Whew!!!