Modeling

While mapping the budgeted/Forecast details from the sheet, the mapping page does not show the Forecast details at the bottom.. It only shows the Actual details....Pls suggest

Author: Shivankur Sharma is a Certified Master Anaplanner and assistant manager in the consulting industry. Anaplan is a versatile cloud-based planning and performance management platform that empowers businesses to make informed decisions and drive operational excellence. But it can be overwhelming to get started in the…

Hi All, I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR. Can anyone have idea about how to do it? For your reference please find the…

Hi everyone. I would like to use RANK function and extract only the data for the most recent date. However, the module have over 10 million cells. RANK function cannot be used... What should I do now? The following error message is displayed. Best regards.

Description of the enhancement: To allow removal of Cancel button when triggering multiple steps actions (Process). How this enhancement will improve your processes: To prevent users from aborting the multiple steps actions resulting in corrupted or deleted tables. For example, user aborted run after deletion of table and…

Hi Anaplan community, I've been trying to give a name to the numbered list with a formula but is not working. Can you please assist? The source module only applies to this list.

Summary Level: Advanced In any line of business, you might be asked to create a dashboard that ranks the sales of your customers based on whatever values are displayed in a two-dimensional grid but based on multiple dimensions chosen from selectors by the user, including top levels. In this example, we will use four…

I used the PERIOD function to fill in the dates for a filter I am using in Month LU line item. But Anaplan isn't reading any dates past 2025. Model calendar ends 2024, is that why?

Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you

Hello, I am completing the Level 1 Model Builder but am getting an error during one of the exam questions. I am pretty sure my formulae are correct but i dont understand what the error is telling me nor what to look to resolve. It is: 'Datatype mapping used for aggregation doesn't match any dimension of the result'. Can…

Hi, From 3.3.5.2 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks. Beginning Inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory…

Some way of filtering line items; Use case is that users are on pages, and different users wanted to see a different set of line items. We were using a line item subset, but since it only could include line item that had numeric values, it could not hold all line items. Current behavior: Line item can only be filtered on…

Currently, New UX only shows page selectors which are dimensions of modules. In classic dashboards, we have the ability to publish any list as a page selector on any dashboard. For example, we publish parent levels(of module dimensions) as page selectors. This is a must to have feature. We feel that New UX is a step…

I'm looking for scenario planning model building. Can anyone point me to a learning tutorial?

Functionality should be added that allows users to iterate a process X times. This could be done with nested processes (which have gained support and would have other use cases), or some other configuration to determine if a process should be run several times. Use Case - pro forma financial statement development. To…

I am still having trouble with 1.5.6.1 in L2, Sprint 1. It says "DAT03 Historic Volumes Invalid Line Item Identifier." I have attached screenshots of how I have mapped things - can someone please help? Thank you.

I'm lost here: "Rename the Action used to Build the P3 SKU list from the saved view" I'm not seeing any additional actions to rename. Also confused at which action contains the SKU flat list to rename "1.5 Load SKU Flat". Any assistance is appreciated.

One common ask that I normally get is having 2 levels in the column headers. While this can be done by adding another dimension, manually hiding excess columns, and publishing them in a page, this ends up taking up unnecessary space if the intention is to just have the 1st level of the column header act as a label. Would…

As per the requirement i need to * Include: Code and items I dont have items as a column to be selected Please help with this, whether i have missed any steps earlier. Regards, Srini

A description of the enhancement requested Week Coverage, also known as forward coverage or stock cover. As an example we have Forecast Sales and Current Stock. Formula should calculate how many future periods of forecast will be covered by Current stock. This is achievable in Anaplan with below function: Look Forward +…

Can someone help me debug this, I've checked my SYS01 - Planning Period Filter Weeks. I am sure I am supposed to see the rest of my weeks and not be limited to week 8.

Hi experts, Does someone provide me with how to hide or inactivate "open source module" in dashboards? The client users are not allowed to go into source module from dashboards. In this case, I also want to conceal module name in dashboards. Regards, inoue

Hi! I just wanted to ask for assistance because my driver module wasn't able to lock the input cells on my Input module. On my input module, dimension is the child while on the driver module, dimension includes the parent and version. Thanks.

So I'm creating a page in the new UX, essentially trying to display Actual and Budgeted amounts for a period. I'm intending to have the Actuals and Budgeted amounts shown as columns and the different categories as rows. I also want to show the variance between these two versions on the same column axis as the versions…

Hi, can anyone help me to figure out what's causing the error for importing the data into EMPO3 Employee Drivers by Role and Employee+Drivers+by+Role module? 1.1) If I load the original downloaded file of "Role List", it's showing the following error. 1.2) So I deleted the Parent column to load it as below. 2.1) After the…

Hi, Appreciate a starting guidance on below for what's needed as a starting example. Rather than let imagination run wild in learning stage and end up with incorrect requirements. Is conditional formatting needed here? Thanks. Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell…

Hello, I would like to clarify the information because I did not find it. I understand correctly that the number of actual working imports from one model to another affects the total processing time as a result of the formula writing curve. Example: In the working model, in case of an error, processing can take 9-15…

So I can't currently can display the Shipping Time, I will attach on what I am seeing. You can slightly see my formula above the screen. What can I do to resolve this bug?

Use Case: In a lot of financial account hierarchies, costs are shown as positive numbers—but need to be subtracted from the totals. With Anaplan, this is easily achievable with line items. The line item formulae are as follows: * Margin = Sales – COGS * Profit = Margin – Costs This is a very simple example that is easily…

Model building in Anaplan has been nothing but a pleasure regarding ease of use and adoption; not only it is an excellent choice to drive standardized models across an organization, but also provides support and follow-up at the needed cadence. And if we talk about the user experience — with upcoming features being added…