Rounding to 2 decimal places

[jasonedwards]

Hi Community.

We use a formula indicator that calculates availability across all services

([[Month Availability - Uptime / By month SUM]] - [[Month Availability - Downtime / By month SUM]]) / [[Month Availability - Uptime / By month SUM]] * 100

We had less that an hour downtime last month out of a total of over 2.5million uptime minutes but the result shows as 100% unless we go to precision 3 e.g 99.998. This looks odd as all other %s are to precision 2.

Is it possible to show the value as 99.99% without it rounding up as reporting 100% isn't accurate / correct?

Thanks

[jasonedwards]

How would I apply this to my formula indicator? ([[Month Availability - Uptime / By month SUM]] - [[Month Availability - Downtime / By month SUM]]) / [[Month Availability - Uptime / By month SUM]] * 100

I just keep return 100% to 2 decimals.

[jasonedwards]

How would I apply this to my formula indicator? ([[Month Availability - Uptime / By month SUM]] - [[Month Availability - Downtime / By month SUM]]) / [[Month Availability - Uptime / By month SUM]] * 100

I just keep return 100% to 2 decimals.

[jasonedwards]

I tried multiple ways but could not adapt ([[Month Availability - Uptime / By month SUM]] - [[Month Availability - Downtime / By month SUM]]) / [[Month Availability - Uptime / By month SUM]] * 100 with any of the suggested solutions.

If anyone knows how I would re-write the above formula please advise.

Used this if statement solution which delivered what I needed

([[Month Availability - Uptime / By month SUM]] -
[[Month Availability - Downtime / By month SUM]]) /
[[Month Availability - Uptime / By month SUM]] * 100 == 100 ? 100 : ([[Month Availability - Uptime / By month SUM]] -
[[Month Availability - Downtime / By month SUM]]) /
[[Month Availability - Uptime / By month SUM]] * 100 > 99.99 ? 99.99 : ([[Month Availability - Uptime / By month SUM]] -
[[Month Availability - Downtime / By month SUM]]) /
[[Month Availability - Uptime / By month SUM]] * 100