Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
iahmadmca1
Contributor III
Contributor III

Round value of percentage

Hi Team,

I am using the below expression for round value, but I could not get the exact round value can you please help me to do this.please find the below expression for reference.

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

-

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

/

Sum([Transceiver Daily Expected Uptime]),'#,##0.00%')

Thanks,

Irshad Ahmad

1 Solution

Accepted Solutions
Gysbert_Wassenaar

The Num function does not round values. It only formats values. Use the Round function to round the values and then use the num function to format the result of the rounding to show two decimals:

Num(Round( ...stuff_to_round... ),'#,##0.00%')


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

Can you explain what you expect to be rounded to what?


talk is cheap, supply exceeds demand
iahmadmca1
Contributor III
Contributor III
Author

Yes Gysbert, i want to expect

suppose in my colume

1.99.50 value--> the output  should come 100.00 round value in percentage.

2.100.2 value--> the output should be come 100.00 like that.

Thanks,

Irshad Ahmad

Gysbert_Wassenaar

The Num function does not round values. It only formats values. Use the Round function to round the values and then use the num function to format the result of the rounding to show two decimals:

Num(Round( ...stuff_to_round... ),'#,##0.00%')


talk is cheap, supply exceeds demand
iahmadmca1
Contributor III
Contributor III
Author

okay thanks

sumitjadhav
Creator II
Creator II

Hi irshad ahmad,

Try this Expression,

-->>num(Round(100.2),'###.##')

OR

-->> Round(100.2,100)

Thank's & Regards,

Sumit Jadhav.