CountIF / CountIF and display Percentage

[nigelapt]

Hi Folks

I am trying to display the 0% value from this expression:

=NUM(Count(IF([DWH Automated Recovery]='Yes',0))/NUM(Count(IF([DWH Severity]='Critical',0)),'0%'))*100

The calculation is

1,042,586 / 1,182,368 = 88%

However no matter what format I apply I still get 88.17779236244553

Be grateful if anyone could advise what I am doing wrong.

Thanks

Nigel

[MarcoWedel · Accepted solution]

Hi,

I think one solution to your format issue could be

=NUM(Count(IF([DWH Automated Recovery]='Yes',0))/Count(IF([DWH Severity]='Critical',0)),'0%')

Besides this you could also replace your If() function with a set expression.

Hope this helps

Marco

[nigelapt]

Marco, thanks very much for the solution.  Apologies for the late reply.  I meant to acknowledge this sooner. Nigel