Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Acn anyone let me know why the message is not showing. I don't want to supress zero values or supress missing values.
I would need to show if there are no values it should populate as 'No fail'
Dimension: Error Code
Expression : If(Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID))=0,'No Fail',
Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID)))
Thanks.
Thanks. Perfect
Is there any way to show only fail text instead of all?