Regarding YTD


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 ?

Best Answer

  • rob_marshall
    Answer ✓


    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,