how to Round off the values in straight table

[#1]

Hi all,

I need % value should represent less than or equal to 100%, I am looking out for the rounding of values.can any one suggest me the best ideas you have so that it will be helpful for my learning process

For Example:

for 100.005 % : i need answer like 100% << like it should not cross 100 %>>

please find the below screen shots for your referance

Expression screen shots:

Number properties:

Thank you,

Muthukumar

[Frank_Hartmann]

use Floor() function:

If(YourExpression>1,Floor(YourExpression), YourExpression)

hope this helps

[sunny_talwar]

or Round() function

[vinieme12]

the first questing to ask is

Is the way you are calculating the expression correct?

[yoganantha321 · Accepted solution]

Hi Muthu,

=Round( Your expression *100)&'%'

It helps you.......