Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
No aggr() required:
Sum({<SupplierID= {"=sum({1} Amount)>1250000"}>} Amount)
Hi.
Please, use the expression below:
Aggr(Sum({$<SupplierID= {"=sum(Amount) > 1250000"}>} Amount),SupplierID)
Hope this helps!
Hi, try
if(sum(Total<SupplierID>amount)>125000,sum(Total<SupplierID>Amount))
Regards!!,
Jannnet-
No aggr() required:
Sum({<SupplierID= {"=sum({1} Amount)>1250000"}>} Amount)
Exactly what I am looking for..Thank you!