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
User | Count |
---|---|
17 | |
14 | |
13 | |
8 | |
6 |