How to convert an annual amount to a monthly amount


I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by much appreciated.

Best Answers

  • rob_marshall


    Have you tried YearValue() / 12?

  • Vamsi_Kaki

    you can also achieve the result using LOOKUP. Below is an example formula. Here time settings is dimensioned by Time (month time scale)

    Source Module.Data[LOOKUP: Time settings. Year]