Decimal Places

[dhakim1996]

Hi, all I am having issue with my data format. 

This is my raw data format 

However, after cleaning, it is returning the following output:

The second line should be 0.09 instead of 9.69. Is there anyway to fixed this?

Please help. Thank you. 

[Ladarthure]

Hi @dhakim1996,

you could do something like

if contains([Rate],E2) then [value]/100

else [value] endif

Could you provide a sample of the file you are using so that we can give it a try directly and maybe find a more elegant solution? 

[grazitti_sapna]

Hi @dhakim1996 , you can use formula tool to achieve your output. here is a sample workflow.

[dhakim1996]

Hi @grazitti_sapna thanks for replying. Unfortunately the issue still persist despite using the suggested method. Is there anyway to resolve this?

[grazitti_sapna]

For me its working fine. Please try using the below workflow.