Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where I have below two columns
col1 col2
A1 A2
A21
A23
A24 A25
I need to have a count of NOTNULL/NOTBLANK col2 where col1 should not be NULL/BLANK.
Basically I need count of rows where values are present in both the columns
Any help on this. I need it in Analysis-UI
@bickyqlik Maye be like:
=count({<col1={"=len(trim(col1))>0"},col2={"=len(trim(col2))>0"}>}col1)
output: