Count Distinct, Multiple Measures (Sum)?

[#1]

Hi,

I have three products which I am trying to sum on a distinct ID number.

My current set analysis is:

COUNT ({$< Product_1 = {">0"}>}  DISTINCT ID)

There are two other products Product_2 & Product_3.

I have tried adding them together using comma separators, however this prints out the wrong number compared what is printed out trough my SQL code.

Help would be appreciated.

[#2]

Thanks, this was the correct one.

[sasiparupudi1]

Count({$<ID = {"=(PRODUCT_1 + PRODUCT_2 +PRODUCT_3) > 0"}>} DISTINCT ID)