Hi All
I am currently trying to automate an excel process on Alteryx, one step in it needs to round down a balance to the nearest 500,000. The excel formual for this is =FLOOR(D5,500000).
How can I do this on Alteryx?
Thanks
Solved! Go to Solution.
Figured out the formula to do it
Floor([Value]/500000)*500000