
Re: Tricky calculations agregations
Sunny Talwar Dec 11, 2017 12:27 PM (in response to Stephane GRIMAUD)You need to use Sum(Aggr(YourExpression, YourDimensions)) to fix this... also check here

Re: Tricky calculations agregations
Stephane GRIMAUD Dec 12, 2017 4:40 AM (in response to Stephane GRIMAUD)Thank you Sunny.
Yes, you're right. Actually, I tried this but difficulty was that a part of the formula has to be summed over all the dimension.
Finally, I succeeded by adding the upper dimension on witch the sum has to be done in the context and by adding it also on the TOTAL option :
Unfortunatly, this formula can not be agregated on other dimension than the one which is specified so I have to multiply the expressions to have always the one to match where I want to use it. Here is the formula for the Département graph, if I want to make a graph per Service then I have to rewrite another expression with Service instead of Département but ok, that works like that.
Of course, if anyone has a better idea, I would be happy to know it.
Thanks in advance,
Stéphane

Re: Tricky calculations agregations
Sunny Talwar Dec 12, 2017 8:53 AM (in response to Stephane GRIMAUD)I think what you have is probably the best you can do.

Re: Tricky calculations agregations
Stephane GRIMAUD Dec 12, 2017 9:26 AM (in response to Sunny Talwar )I think so too. Thanks anyway Sunny .
Talk to you. Bye !
Stéphane

