Count with Exclude

[danieldors]

I'm trying to exclude any data from unit 88527 from the formula below.  Thank you.

=count({<Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'>}distinct [Access Number])

[Unit]<>{'88527'}

[Taoufiq_Zarra]

Maye be :

=count({<[Unit]={"*"}-{'88527'},Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'>}distinct [Access Number])

[danieldors]

Thank for the response but that didnt resolve the problem.

[Taoufiq_Zarra]

can you share a sample data and the expected output ?

[Saravanan_Desingh]

One solution.

=count({<[Access Number]={"=[Unit]<>'88527'"},Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'>}distinct [Access Number])