In general the formula like:
SUM([%TIME%].[2006.01]:[%TIME%].CURRENTMEMBER,[MEASURES].[/CPMB/SDATA])
will work correctly for base members. Please replace 2006.01 with the first member of your TIME dimension.
For parents you have to experiment with IIF...
Can you explain the desired calculation logic using some example instead of incorrect formula?
Hi Vadim,
Thanks for your answer, to give an example we want if we select time 2016.12 to obtain the amount of all month before this date (including 2016.12).
I don't know if it is clear for you ?
It is used by my company to see depreciations.
Best regards
Stéphane
Add comment