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.
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?
Hi @dhakim1996 , you can use formula tool to achieve your output. here is a sample workflow.
Hi @grazitti_sapna thanks for replying. Unfortunately the issue still persist despite using the suggested method. Is there anyway to resolve this?
For me its working fine. Please try using the below workflow.
