Disregard the selection - set analysis

[#1]

Hi,

This is the exact formula i am using. I am trying to do a count of DateofService(this is the dimension) and a count when the ClaimsAmt>0. But i need to disregard the selection. I know the basic {1} set analysis but i am not sure how to apply it to this formula.

=count(TOTAL Distinct if((DateofService<=$(v_IBNRStDt)) AND ClaimsAmt>0,DateofService,Null()))

Thanks.

[#2]

Set analysis can only be applied to aggregation functions... in this case you are using count().

You should be able to do something like this:

=count({1} TOTAL Distinct if((DateofService<=$(v_IBNRStDt)) AND ClaimsAmt>0,DateofService,Null()))