Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Round formula calculating NULL for every record

CDIns
8 - Asteroid

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, 

2 REPLIES 2
binuacs
20 - Arcturus

@CDIns the formula should be Rate([Rate],0.00001)

image.png

CDIns
8 - Asteroid

Ah, I see what i did wrong. thank you, @binuacs !

Labels