Spreading amounts

Hi Anaplan Experts,

I'm not using native time and wanna use the SPREAD function. However, This function needs a time scale. Some functions can't run in custom time, such as OFFSET, LEAD, PREVIOUS, ETC.

What are your thoughts on calculating asset depreciation with the LOOKUP function?.

Kind Regards,

Accepted answers

All comments

LipChean_Soh

Hi @wandis

I would suggest taking a hard look at why you're not using standard time, because as you rightly discovered, you're not able to use some of the most powerful formula and keywords associated with native time within Anaplan.

But if you must present your final numbers with fake time, then i would suggest that you do all your calculations in CALC modules with native time, so that you can use those SPREAD, OFFSET, LEAD, PREVIOUS, etc formulas, before you do a LOOKUP connecting your REP modules with the CALC modules.

Otherwise, coming up with workarounds to simulate the effect of SPREAD, OFFSET, LEAD, PREVIOUS, etc will likely waste more space, and make it less sustainable for future model building.

Thanks,

LipChean

wandis

Hi LipChean,

All data input is in custom time. Could you advise me to link native time and custom time?.

Thanks.

LipChean_Soh

Hi @wandis

Can you put up some screen shots to explain why the input is in custom time?

Thanks,

LipChean

ChrisAHeathcote

@wandis

You can run all your calculations using Anaplan time and then map them back into your custom time list.

Here you will be able to use all time functions as required but will then present your calculations back using your custom time list.

The drawback here is that you will have to manage the mapping table. Ideally, set this up in such a way that the mapping is automatic otherwise you will need to update it manually each time.

I would also question why you have chosen to use a non native time list as this should always be your last option once you have fully explored the possibility of using native time.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…