if result of count - Combing num and count with if

[bensomers]

If someone could please help with this.. Should be fairly straightforward but I am obviously missing something obvious.

I have a collumn of data that is either Yes or No. If the percentage of Yes is higher than 98.00% I would like to return "SLA Met".

I have managed to return the percentage of Yes using:

=Num(Count({<SLAMet= {'Yes'}><slamet= {'yes'}="">} SLAMet)/Count(SLAMet), '#,##0.00%')</slamet=>

But I can't seem to figure out how to add 'if above 98.00%, return "SLA Met"'

Any suggestions?

[Channa]

try

IF(Count({<SLAMet= {'Yes'}><slamet= {'yes'}="">} SLAMet)/Count(SLAMet)>.98,'meat','non')

[bensomers · Accepted solution]

Thank you Channa.

I had to tweak it slightly to get it to work but you gave me the foundations to figure it out. Really appreciate it!

This is the adjusted expression that worked:

=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'meat','non')