My current period is set to May 23. I am calculating YTD by taking it in time dimension, but it is calculating YTD by taking values upto May 23 and I want to calculate by taking values upto April 23. How should I do it ?
Do you have Switchover turned on in your Version settings?
And to get the YearToDate working across versions, simply turn off the Switchover checkbox for the YearToDate line item.
Timesum() is a known performance issue when using TimeSum() with Time in the Applies To. TimeSum should only be used without Time. From Anapedia:
Instead of Timesum(), if you have to go this route, use Movingsum() instead as it is optimized for line items containing Time as a list (in the Applies To).
Hope this helps,
Hi, if native YTD funcitonality doesn't work for you then you'll need to use timesum function to get the values you need.
, this solves the problem.