Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rounding

Hello,   I want to do rounding for numbers something like this below. 16.67 to 17. 17.78 to 18 I tried with ROUND, ROUNDUP, and MROUND but didn't work.    Can anybody help me?   Regards, Pa...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    I am not sure if I understood your question correctly, but please try something like the below.

     

    Round result = ROUND(17.78,0)
    or
    Round result = ROUND([yourmeasure],0)
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

I am not sure if I understood your question correctly, but please try something like the below.

 

Round result = ROUND(17.78,0)
or
Round result = ROUND([yourmeasure],0)
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

With this ROUND([yourmeasure],0). I solved the problem.