Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Round off the percentage values?

Hi All,

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

Screenshot_1.png

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%

Screenshot_2.png

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

Thanks.

Muthu

13 Replies
Not applicable
Author

Thanks for your response Sumit.

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

sumitjadhav
Creator II
Creator II

Hi Muthu,

Try the Below Expressions,

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

and

-->>Round( 99.98,0.02)

Thank's & Regards,

Sumit Jadhav.

tamilarasu
Champion
Champion

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))

Not applicable
Author

Thank you Jonathan