Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks for your response Sumit.
i have tried the expression it is not working and iam getting same result onit
Hi Muthu,
Try the Below Expressions,
-->>num(Round(100.07),'###')
and
-->>Round( 99.98,0.02)
Thank's & Regards,
Sumit Jadhav.
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))
Thank you Jonathan