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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

I dont understand the rounding rules you want to apply. 99.98 does not round to 99, it will round to 100, and what does "either 99.98 or 99%"  mean? You need one or the other.

In general,

round(x, y) will round x up or down to the nearest multiple of y. If y is omitted, use 1

ceil(x, y) will round x up to the nearest multiple of y. Likewise y defailts to 1 if omitted.

floor(x, y) will round down to the nearest multiple of y.

To produce 99.98, then use something like

=Round(99.977, 0.01)

To "round" 99.98 to 99, then use

=Floor(99.98, 1)


Similarly for 100.01

=Round(100.01, 1)

=Floor(100.01, 1)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

13 Replies
Anonymous
Not applicable
Author

Try using Num(<your field/Expression>/100,'##.#0%')

Not applicable
Author

Thanks for your response Shiva.

But the above Expression is Not working

for your Exapression iam getting the Output as

Screenshot_3.png

But i need an out put like

100.01 % as 100%

99.98 % as either 99.98 or 99%

The Expression that I am using:

=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%')

hariprasadqv
Creator III
Creator III

Hi ,

Change the number format in Number tab of that expression.

Select Fixed and set 0 Decimal. if you are not multiplying the factor with 100 in you expression check

"Show in Percentage in the Number Tab"

Not applicable
Author

Thanks for your response Hari Prasad

I have checked your Logic. It is also not working

I am getting the output as 100%  for all fields

even 99.98 % also getting 100%

But I need an output like

100.01 % as 100%

99.98 % as either 99.98 or 99%

Thanks,

Muthu

hariprasadqv
Creator III
Creator III

Try ceil()  or Floor()

jonathandienst
Partner - Champion III
Partner - Champion III

I dont understand the rounding rules you want to apply. 99.98 does not round to 99, it will round to 100, and what does "either 99.98 or 99%"  mean? You need one or the other.

In general,

round(x, y) will round x up or down to the nearest multiple of y. If y is omitted, use 1

ceil(x, y) will round x up to the nearest multiple of y. Likewise y defailts to 1 if omitted.

floor(x, y) will round down to the nearest multiple of y.

To produce 99.98, then use something like

=Round(99.977, 0.01)

To "round" 99.98 to 99, then use

=Floor(99.98, 1)


Similarly for 100.01

=Round(100.01, 1)

=Floor(100.01, 1)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Use thisNum((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.#0%')

sumitjadhav
Creator II
Creator II

Hi Muthu,

Try this Exppression,"Round(99.98,0.04)" if it works.

Thank's & Regards,

Sumit Jadhav.

Not applicable
Author

Thanks for your response Jonathan

Actually, i want

100.07 as 100%

and 99.98 % as 99.98 itself

But both I need in single column

Is there any Possibilities to get both