Aggr function problem

[#1]

Hi

I need a help....I would like to calculate the total amount of the suppliers with more than 1250000

=if(aggr(sum(Amount),SupplierID)>1250000,sum(Amount))

the formula is giving me the total amount not the sum of the amount for the ones with more than 1250000(Amount)

[jonas_rezende]

Hi.

Please, use the expression below:

Aggr(Sum({$<SupplierID= {"=sum(Amount) > 1250000"}>} Amount),SupplierID)

Hope this helps!

[Anonymous]

Hi,  try

if(sum(Total<SupplierID>amount)>125000,sum(Total<SupplierID>Amount))

Regards!!,

Jannnet-

[Anonymous · Accepted solution]

No aggr() required:

Sum({<SupplierID= {"=sum({1} Amount)>1250000"}>} Amount)

[#5]

Exactly what I am looking for..Thank you!