GetSelectedCount, but only those which nas not null in some other field.

[retko1985]

I want to divide by number of selected values in some field, like GetSelectedCount(Customer). But if the selected Customer has null in some other Field, like in Sales_Amount, it should be excluded, even if he is selected.

Do you have some suggestions?  Thank you.

[sunny_talwar]

May be use Count() instead?

Count({<Sales_Amount = {'*'}>}Customer)

or this

If(GetSelectedCount(Customer) > 0, Count({<Sales_Amount = {'*'}>}Customer))