topic Re: Round value of percentage in Connectivity & Data Prep

Round value of percentage

iahmadmca1 — Fri, 02 Apr 2021 07:52:46 GMT

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

Re: Round value of percentage

Gysbert_Wassenaar — Sun, 26 Mar 2017 15:37:49 GMT

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

Re: Round value of percentage

iahmadmca1 — Sun, 26 Mar 2017 16:47:23 GMT

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

Re: Round value of percentage

Gysbert_Wassenaar — Sun, 26 Mar 2017 16:56:10 GMT

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

Re: Round value of percentage

iahmadmca1 — Sun, 26 Mar 2017 17:04:02 GMT

okay thanks

Re: Round value of percentage

sumitjadhav — Wed, 19 Apr 2017 06:25:16 GMT

Hi irshad ahmad,

Try this Expression,

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

-->> Round(100.2,100)

Thank's & Regards,

Sumit Jadhav.