Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a easy example regarding to my problem. You will see a table which includes Start and End. Now the ID should counted when Start and End is not empty. How to build that?
Thanks...
Try this:
=Count(if(Len(Trim(Start)) > 0 AND Len(Trim(End)) > 0, ID))
Hi Hans, you can use:
=Count({<End={"=Len(Trim(End))>0"}, Start={"=Len(Trim(Start))>0"}>} ID)
=Count({<ID={"=Len(Trim(End))>0 and Len(Trim(Start))>0"}>} ID)
Btw the empty fields aren't Null(), they have a blank value.
You can check when a value is null because you can't select it, in this case you can select the blank value.
try this:
=count({<Start={"=if(len(trim(Start))>0 ,Start)"},End={"=if(len(trim(End))>0 ,End)"}>}ID)
=Count( If( not (IsNull(End) and IsNull(Start)), ID))
In your sample End and Start are not really null, so try:
=Count( If( Len(Trim(End))>0 and Len(Trim(Start))>0, ID))
You could you set analysis as well.