Date of version start

Vladimir

Hi,

please help

I've got versions with switchover:

1.Actual

2.Budget-mar 19 switchover

3.Forecast-June 19 switchover

 

I need to have 2 line items showing:

1. Budget start date

2. Budget end date

nathan_rudman

you can do this using the formula ISACTUALVERSION() for example.

The switchover means in the past Anaplan considers it to be the actual version.

 

So if you a line item like (with time and version dimension) in a module called SYS01: Time Filters:

Detector = IF ISACTUALVERSION() then 1 else 0

Switchover date(date formatted,time summary: first non blank) = if detector = 0 and previous(detector) = 1 then start() else blank

That gives you the date.

Now you need to extract that into a module without time like SYS02: Time Settings:

'SYS01: Time Filters'.Switchover date[select:time.all periods]

 

You can find this in the time filters app available on the app hub