How to convert an annual amount to a monthly amount

wld002

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.

rob_marshall

@wld002

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]

rob_marshall

@Vamsi_Kaki

Yes, the lookup will work, but Yearvalue() will perform better because the lookup is already built into the function.