
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CountIF / CountIF and display Percentage
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
- Tags:
- countif
- Expression %
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Marco, thanks very much for the solution. Apologies for the late reply. I meant to acknowledge this sooner. Nigel
