Sum Check in Set Analysis

[retko1985]

Hello,

I have a situation, where I want to ignore values in some field based on the sum of another field.

Here is the example (look at attached QVW). I have a list of contracts, sale amounts and some other amount. I want to do the sum of sales for those contracts and specify in set analysis that I want to do SUM of Sales only for those contracts, which has the SUM of Amount more then 0.

Therefore in provided QVW I want a sum of Contracts 1 and 2. for Contract 3 the Sum of Amount is 0, so those should be ignored.

Please advise.

Thank you.

[tresesco · Accepted solution]

Try:

Sum({<Contract={"=Sum(Amount)>0"}>}Sales)

[Anil_Babu_Samineni]

This?

Sum({<Amount = {'>0'}>} Sales)