Round of decimal values in double

Question

Hi,

I have field that is imported from Excel. The default data type assigned to this field was v_string. The value on alteryx looked in exponential format. So I tried to convert it into fixed decimal format. But the value displayed in null. Hence I converted it using double. Now the issue I am facing, is some values have 4 digits after decimal and some have 5,6,7. I want this to be uniform. Can someone help with this.

atcodedog05 · Answer

Hi @hegdepavithra10

Here is what you can do

Set datatype to Fixed:Decimal like below

Scale is number of decimal points

Output:

Happy to help 🙂

Cheers and Happy Analyzing 😀

round.yxmd

hegdepavithra10 · Answer

hi,

i tried the solution you have provided. I used round([Field],0.0001). This however, turned some of the values into 0.001 and others to 0.0001. Can this be made uniform?

JosephSerpis · Answer

Hi @hegdepavithra10 I mocked up a workflow that showcases how to do that. Let me know what you think?

Round_041120202.yxmd