Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need some help to count the number of line empty in 2 columns.
In the example, when the column "Item" is filled, I would like to count the number of lines which have both "Info 1" and "Info 2" empty.
In this case it should be 2 (Line B and Line E).
Item | Info 1 | Info 2 |
A | X | |
B | ||
C | X | X |
D | X | |
E | ||
F | X | |
G | X |
Does anybody know how to do this formula?
Many thanks,
Wil
It’s not nice but should do the trick
using item as dimension in a chart
Count(if(len(trim(field1))>0 and len(trim(field2))>0,1 ))
or
as text or kpi object
Count({< Item={"*"}>}if(len(trim(field1))>0 and len(trim(field2))>0,1 ))
could have some syntax error as I couldnt tried
best,
It’s not nice but should do the trick
using item as dimension in a chart
Count(if(len(trim(field1))>0 and len(trim(field2))>0,1 ))
or
as text or kpi object
Count({< Item={"*"}>}if(len(trim(field1))>0 and len(trim(field2))>0,1 ))
could have some syntax error as I couldnt tried
best,
Amazing @RafaelBarrios ! It worked for me the 2nd formula. I just had to put "=0" instead of ">0".
It worked like this:
Count({< Item={"*"}>}if(len(trim(field1))=0 and len(trim(field2))=0,1 ))
I appreaciate your help.
Thank you very much.
Regards,
Wil
upssss
sorry..... well seen 👍
im glad it works for you