Help with set analysis

[#1]

Hi,

I am trying to do something like the following:

COUNT(DISTINCT{$< (amount-pay-prep)={">0"}>} P_ID)

how can i handle with the condition (amount-pay-prep), it shows error and i need to compare the result of these values. I tried to use RANGESUM, ,dont know if it is in the proper pplace or not but also it does not work.

appreciate any help.

Thanks

[PrashantSangle]

Hi,

Try like

COUNT({<amount-pay-prep={">0"}>}Distinct P_ID)

or Count(if(amount-pay-prep>0,Distinct P_ID))

Regards

[prajapatiamar38]

Hi,

Try this

=COUNT({< (amount-pay-prep)={">0"} >}DISTINCT P_ID)

Thanks

[Kushal_Chawda]

try like this

count(DISTINCT {<[amount-pay-prep]={">0"}>}P_ID)