Help in expression

[abeyphilip]

Hi,

My data looks like this. The requirement is to count the customers that are deactivated (having status as "D"). In the example below - my count of deactivated customers  should return 1 - i.e. CustC. Because only for that customer the status is D for all dates. Can this be done as an expression?

Thanks,

Abey

[Gysbert_Wassenaar · Accepted solution]

Try: count({<Cust= e({<Status-={'D'}>} Cust) >} distinct Cust)