Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data with below
Dimension: EmployeeName
Expression: =If(MixMatch(Outcome='Update',
'Updated to All',
'Updated to Outstanding'),Count(ID))
But the data is showing blank values under expression as there is data in the database. can anyone please suggest me is there any error in expression?
I think
Outcome='Update' is true or false --> -1 or 0
MixMatch(-1/0, .........) always 0
Count(ID) never
Try
Count(If(MixMatch(Outcome,'Update','Update to All','Updated to Outstanding'),ID)