Count + IF + Distinct

[wcamargo]

Hi all,

I'm doing a count of column "Item" if both "field1" and "field2" are empty, but I need to count "distinct" for the column "Item".

Actual formula:

Count({< Item={"*"}>}if(len(trim(field1))=0 and len(trim(field2))=0,1 ))

I don't know how to include "distinct" on this formula for column item.

Does anyone know how to do it?

Many thanks,

Wil

[RafaelBarrios · Accepted solution]

I know that formula 😅

try

Count(distinct {< Item={"*"}>}if(len(trim(field1))=0 and len(trim(field2))=0,Item ))

best,

[wcamargo]

Thank you @RafaelBarrios ! Very powerfull formula.

Regards,

Wilson