annual assumptions

Monthly modelling driven by annual assumptions

Hey Modano team and users,

I have been fiddling recently with creating models where the main time series is monthly, where the client would like to adjust assumptions on an annual basis. So far I've been doing this by making a custom annual assumptions module that feeds into the monthly modules via an xlookup, however this gives freeform formula errors as xlookup inherently references two rows in the annual assumptions module to pull out the given year's assumption.

Subscribe to RSS - annual assumptions