Profile Function for Revenue Recognition

Hi everyone,

My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year.

We have 2 metrics "Bookings" which are sales associated with contracted revenue, and "Installs" which are when the booking begins being recognized as revenue (as the product is implemented for the customer). We use percentages for Month 0 (the month of the booking) to Month 9 (9 months after the booking) to budget when things will install, pictured below:

The issue we are having is now that we are in our 2023 budget process, we changed these numbers and they are not time formatted, so our 2022 budget now shows incorrect numbers.

Does anyone have any potential solutions?

Thanks in advance!

Accepted answers

All comments

Misbah

@CamdenMaggos

You will have to add Year dimension to this module. And change the downstream/referenced formulae accordingly to reflect the correct year numbers.

Misbah

Miz Logix

CamdenMaggos

Can you use the profile function with time formatted modules? I would need the bookings from december 22 to have the same waterfall as the others in 2022 that carries into 2023

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…