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

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…