Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Round up Formula required

kngowtham
5 - Atom

I need a round up formula to the whole number (not rounding to the nearest integer)

 

For Ex:

650.75 should become 651

650.25 also needed to be 651

650.00 should remain 650

8 REPLIES 8
Aaron_Harter
11 - Bolide

Hi @kngowtham

 

Check out the CEIL function:

 2.PNG

JosephSerpis
17 - Castor
17 - Castor

I mocked up a workflow let me know what you think?

 

Round_Up.JPG

CherylH
8 - Asteroid

How do you round up or down?   This formula only rounds up:  ceil([Case Sales Vol CNV])

 

For example:   651.25=651    651.75=652

mst3k
11 - Bolide

floor() will always round down to the nearest integer:

651.25 becomes 651

651.75 also becomes 651

CherylH
8 - Asteroid

What is formula to round to nearest integer?

 

651.25=651   and 651.75=652?

 

I know it's a entry level question....

atcodedog05
22 - Nova
22 - Nova

_

Christina_H
14 - Magnetar

@CherylH You can use Round(x,mult) to round to the nearest integer e.g. Round([Number], 1)

CherylH
8 - Asteroid

Thank you!

Labels