I added a formula tool onto my dataset to calculate like a rate. This works fine, however, the rates are like 12 decimals long. The system these rates will be uploaded to only can handle up to 5 decimal places. Directly under my rate formula, I created another formula referencing my rate column and using the following formula:
round([Rate],0.00000)
Its calculating NULL for every record. For reference, my RATE column is double data type.
Is my formula incorrect?
thank you,
Solved! Go to Solution.
@CDIns the formula should be Rate([Rate],0.00001)
Ah, I see what i did wrong. thank you, @binuacs !