Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I know that formula 😅
try
Count(distinct {< Item={"*"}>}if(len(trim(field1))=0 and len(trim(field2))=0,Item ))
best,
I know that formula 😅
try
Count(distinct {< Item={"*"}>}if(len(trim(field1))=0 and len(trim(field2))=0,Item ))
best,