Distinct Count of only those Items whose sum(QTy) is greater than 0

[rahulsud007]

Dear All,

I  have a requirement in which I need distinct count of only those items whose sum(qty) is greater than 0.

In the attached QV app, the count of item nos should be 3 as sum(qty) for P2 is 0 hence it should not be counted.

Kindly suggest.

[rahulsud007]

Dear All,

Thanks all for your help. Still I didn't get a solution here

Please check my attachment suppose if we select any particular field in the list box the value which we are getting in the text box and in the count field should be shown even if no selection of Ile_Ageing has been applied.