Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'}
Maye be :
=count({<[Unit]={"*"}-{'88527'},Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'>}distinct [Access Number])
Thank for the response but that didnt resolve the problem.
can you share a sample data and the expected output ?
One solution.
=count({<[Access Number]={"=[Unit]<>'88527'"},Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'>}distinct [Access Number])