How to Round off the percentage values?

[#1]

Hi All,

I need the below percentage values to get Roundup as 100%.

I have Tried by using Round, Floor and Ceil function .it works for 100% but 99.98 % is also turning as 100%

Requirements I need:

100.02: as 100 %

99.92: as either 99.92 or 99%

can anyone help me fixing it? so that it will be help full for my learning process

Thanks.

Muthu

[#2]

Thanks for your response Sumit.

i have tried the expression it is not working and iam getting same result onit

[sumitjadhav]

Hi Muthu,

Try the Below Expressions,

-->>num(Round(100.07),'###')

and

-->>Round( 99.98,0.02)

Thank's & Regards,

Sumit Jadhav.

[tamilarasu]

Hi Muthu Kumar,

Maybe this?

Round((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

-

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

/

Sum([Transceiver Daily Expected Uptime])),

If((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

-

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

/

Sum([Transceiver Daily Expected Uptime]))>100,1,0.01))

[#5]

Thank you Jonathan