How to Round Down to nearest 500,000 in Alteryx

[MattDuncan]

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

[MattDuncan · Accepted solution]

Figured out the formula to do it

Floor([Value]/500000)*500000