Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

MROUND in Alteryx

caltang
17 - Castor
17 - Castor

As per ExcelJET:

https://exceljet.net/functions/mround-function#:~:text=The%20MROUND%20function%20rounds%20a,half%20t....

 

exceljet mround function.png

 

I am looking to round a value to the multiple of 5.

 

Does anyone know? Thanks!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
2 REPLIES 2
DataNath
17 - Castor

Hey @caltang, you'd just use the Round() function. Round(x, mult) where 'mult' is the multiple, in your case 5:

 

 

Round([Number], 5)

 

7.png

 

caltang
17 - Castor
17 - Castor

Silly me! I somehow forgot that existed ahha! Thanks @DataNath !

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels