Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?
=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'Pass','Fail')
Thanks!
Try using a dual()
instead of returning Pass / Fail, dual('Pass',1) / dual('Fail'),0)
In theory it will display the text but have the number for calculations just like dates