Aggr function

[HelenaBow12_]

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!

[brunobertels]

Hi 

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 

[rui24]

Hi HelenaBow12_

What is your "ProbabilityOfSale" ?????

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

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