Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I’m having problems with the below expression.
I have not made any selections in dimension other what is in this expression.
=sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>}$(vCO_POSIBLE_TURNOVER))
The varible “vCO_POSIBLE_TURNOVER” is
(sum($(vCO_NET_AMOUNT_EUR))+(sum($(vCOINVO_NET_AMOUNT_EUR))))
And this variable works outside this expression.
Thanks in advance.
Hi Michael, Please use set Analysis also in the the variable :
LET vCO_POSIBLE_TURNOVER =
(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCO_NET_AMOUNT_EUR))+(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCOINVO_NET_AMOUNT_EUR))))
in your expresion instead of writeing
$(vCO_POSIBLE_TURNOVER))
write:
$(=$(vCO_POSIBLE_TURNOVER)) )
Michale,
Sum of sum will not work.
Modify your valriable so that it becomes A+B and not sum(A)+sum(B)
Fabrice
Hi
You cannot nest SUMs directly; use aggr() if necessary - something like this:
sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} Aggr($(vCO_POSIBLE_TURNOVER), ChartDim1, ChartDim2, ...))
(where ChartDim1, ChartDim2 is a comma separated list of dimensions in your chart or table.
HTH
Jonathan
I thank you all for your help…… I have tried them but they did not succeeded, so I will keep on trying new ways to get this solved.
Br
Michael
Hi Michael, Please use set Analysis also in the the variable :
LET vCO_POSIBLE_TURNOVER =
(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCO_NET_AMOUNT_EUR))+(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCOINVO_NET_AMOUNT_EUR))))
Thank you dathu.... this one worked 🙂