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
21 - Polaris

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

image.png

CDIns
8 - Asteroid

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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels