topic Re: Aggr function in App Development

Aggr function

HelenaBow12_ — Wed, 04 Jan 2023 12:00:16 GMT

Hello everyone!

I have a formula like :

(Sum (TOTALAMOUNT) - Sum (TOTALAMOUNT111)) * ProbabilityOfSale

I need to get a sum of the results of this formula. As far as I understood so far the nested sum function is not possible to use and the Aggr function has to be used. However, I am not quite sure how to implement this.

Feel free to share your suggestions and thank you in advance!

Re: Aggr function

brunobertels — Wed, 04 Jan 2023 14:32:25 GMT

Not sure

but may be somthink like this

AGGR( (Sum (TOTALAMOUNT) - Sum (TOTALAMOUNT111)) * ProbabilityOfSale ,YourDim1,YourDim2,)

you add the Dim within you want the Aggr to be calculated

Re: Aggr function

rui24 — Wed, 04 Jan 2023 14:48:47 GMT

Hi HelenaBow12_

What is your "ProbabilityOfSale" ?????

num(Sum(TOTALAMOUNT)) - ((sum(TOTALAMOUNT111))) * ProbabilityOfSale

Only calculate if you select a value in fielter to "ProbabilityOfSale"