Advise on building methodology

Hi,

Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month.

Thank you

Accepted answers

All comments

JaredDolich

@neg177

Neg! How've you been? You deserve the Community award for most participation. Great question.

Easy to handle by the way. Two methods:

MONTHVALUE
system module that is set to the day level. Create a line item formatted as a period (month) and use the PERIOD(START()) function to identify the month. Then in your planning module you can LOOKUP the month value that way.

neg177

Hi Jared,

I believe I have my SYS modules already set up to do so, (Ill add a screen shot of them), but what I'm trying to do overall is dayify a monthly number that is in one of my modules, and then take the dayified first of the month totals, (excluding Weekends and Holiday's), and then divide those dayified first of the month totals by the month total.

Trying to take this monthly total

Use Simple math to break apart the Monthly number in accordance to days of the week

Then in this module it will be daily and I only want to look up the amount of every first day of the month

SYS Modules

MarkWarren

What is the select in Funding Dayification Totals?
(You should just put that formula in Funding Dayification Daily, no need to "daisy chain" it.)
It looks like you recreate the value of D04 Total Funding on C06b, and just copying it across Days.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…