which is better - count({$<columnA={"*"}>columnB} or count({$<columnA={"<> Null()"}>}columnB)

[sonikajain]

Hi all,

Please help me understand the differences in execution and the way of execution of count({$<columnA={"*"}>columnB} and count({$<columnA={"<> Null()"}>}columnB) .

My requirement is to count the number of columnB records where the field columnA is not null.

Please share if there is a better way to do this.

Thanks.

[Anonymous]

One way would be:

=count({$<ColumnA-=>} ColumnB)

All values from B where A is not null