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.

Accepted answers

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]

All comments

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.

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…