Hi all, I have a challenge and I am searching for the best solution. I have (a lot of) sales data and I am using that data to forecast on a daily level for the coming weeks. National holidays have a h…
Hello I am trying to create a profile to spread revenues by client (i.e. When a client signs a contract in the future, when will the revenues occur based on past performance. First I have a module tha…
Dear Friends, I need some help from you. I want to update my list. My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).
Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2…
Level 1 model builder training module - Creating a line subset section. Before jumping to the next session the training module sats subset #E2 Employees need to be created and to be shown as the above…
Hi Team, I have an issue whereby I can't SUM from 1 Hierarchical list to 2 different Lists....let me explain with an example I have Source Module which is dimensionalised by #Employee (the parent item…
New to anaplan platform, i want to insert the formula in my system module and i know we can search it in anaplan anapedia under all functions tab to see which function to apply. But it's not easy to …
As a model builder, you have to define line item formats over and over. Using a text expander/snippet tool, you can speed up the configuration of modules. When you add a new Line Item, Anaplan sets it…
Hi, I have list A with property X and list B. Also I have module where I have list A as dimension and line item. In that line item i need to get data from list b based on property X which i created. P…
Hi , I have 2 lists. Months(1,2,3,45-...etc) and Qtr(1,2,3,4...etc). We need to create module to map months to Qtrs. That is for 3 months in one Qtr. That is for month values 1,2,3 The Qtr value shoul…
Hi, Apologies if this doesn't make much sense but I am fairly new to Anaplan. I have a module with multiple line items, each retrieving a month from other modules (Formatted to Time Period: Month). I …
Hi I would like to create formula to calculate moving average for YTD and YTG. Here's the formula i input MOVINGSUM(Actual, -11, 0, AVERAGE) to calcuate YTD run rate, MOVINGSUM(Remaining, -11, 0, AVER…
Hi, I have a weekly module and when change the current period to next week then my previous weeks data gets deleted, how i can keep my previous data and move to the next week? Thank you!
"Rule 1.04-02": Article 1, Chapter 4, and Rule 2 – “Utilize Show Content On/Off for Different Functional Areas”. “To reduce maintenance, create separate Functional Areas for dashboards and modules (e.…
Hi, I have line item (status interco) where if amount blue and red not same it will be give text "Unbalance" but i dont know how to compare every item Any ideas are appreciated. Thanks,
Hi Team, I have a Selective Access List which has an internal hierarchy within the list (Parent items that are not from another List) published as Page Selector to a Dashboard. This example is a List …
Hi there, Suppose I want to calculate total training costs per department. E.g. say I have: Department Training Cost ($) Finance A 50 Finance B 60 Marketing A 50 Marketing D 100 HR & 50 Finance # 30 T…
Hi Team, I have a module with Employee List on the the Rows, Time as Columns and Line Items as Pages. I would like to Filter the Employee items on whether the Time Value selected is greater than zero …
Is there a way i can hide/filter those numbered lists in between that has no data. In the screenshot below, i need to hide numbered list #2, #4 and #5. Thanks in advance for any help.
“Rule 1.03-03": Article 1, Chapter 3, and Rule 3 – “Set a Landing Dashboard by Role”. “Different roles should require a different entry point. Avoid a generic landing page if possible and create a spe…
Hi, I want to calculate depreciation of assets using declining balance depreciation method on Anaplan. I went through Anapedia's financial function pages to find function like Excel's VDB, but couldn'…
Hi Team, Is there any method to place Parent items within a Line Item Subset at the bottom of the group rather than at the top? In the below example 'Total Run-Rate Expense' is the parent of the 3 ite…
Hi, I am trying to use a rank function in a multi hierarchy list but the rank is not resetting in other hierarchy. I am expecting that the first list member in the hierarchy should start to 1. Thanks …
Hi everyone. I would like to change the number of lines displayed for each user. In this case, I would like to display the 3rd to 10th lines to user A and display the 12th to 20th lines to user B. So …
What is the best way, without Anaplan Connect, to change the current period? I'm creating a process that the end user will run to refresh all data...how do I add changing the current period to this pr…
We have a 10-minute rollback sometimes and we are very careful to ensure formulae and entries are correct. The one annoying thing is case sensitivity on views. I had to wait 12 minutes because I saved…
I am wondering if there are any virtual courses for The Anaplan Way. I have completed Level 1 and Level 2 Model Builder but would like to complete The Anaplan Way to achieve my Certified Model Builder…
