sum

[upaliwije]

Hi

In my data model I have following records

Claim No	amount
100	1000
100	2500
101	14000
102	4500
103	2000
102	5000
101	12000
100	500

In my straight I want to sum amount by Claim No and show the results where Amount is<25000. I have written the following expression but it is not working

SUM(if(sum(amount)<25000,amount))

My expected result should be

Claim No	amount
100	4000
102	9500
103	2000

[sushil353]

Hi,

You can simply use dimension limit functionality:

chart property>DimensionLimit

check for show only value that are > Less than > 25000 >exact amount

HTH

Sushil

[avinashelite]

try like this :

if(sum(amount)<'25000',sum(amount))

[Kushal_Chawda]

Expression:

Sum({<[Cliam No] ={"=sum(Amount)<25000"}>}Amount)

[upaliwije]

It is not working

[tresesco · Accepted solution]

Sum({<[Claim No]={"=sum(Amount)<25000"}>}Amount)

[avinashelite]

its working for me !!! need to check your data once , can you please share your app.

Pleas find the attachment

[upaliwije]

Thanks

Is does not give desired results. Can u pls test this and reply with the sample QV doc

[Kushal_Chawda]

I had modified it

[upaliwije]

Thanks all of u