Hi All, I have a module with a subset of numbered list applied in its dimension. We want to derive the S.No/ Count of Items in the list in a line item in the module eg: If the list has 3 items A,B,C i…
Here's the official documentation on the formula - https://help.anaplan.com/138ee6b0-34a3-4654-b944-f655e6b28ad8-ISACTUALVERSION As per the article, ISACTUALVERSION returns TRUE for Actual Version and…
Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the tex…
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'R…
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the …
HIya, I am currently pulling various modules out from a large model to provide better user security, I then plan to pull the data from the top level module back into the main business model. Is this s…
Hi, I have an issue related to time filters. I have a module dedicated to time filter which I use for my other modules to show the relevant years/months. My fiscal year is from jun-may, and I want a f…
Does Anaplan treat List Subset as a different List? Because when we changed a module dimension from "Product list" to a subset of "Salable Product list", all the filters got removed.
Thank you to all our forum members who attended yesterday's session with @Paul and I - we hope you enjoyed it and took away some food for thought. Special thanks also to Stephen Brook from the Product…
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the u…
Hi, I've been building a module with a list composed of several children and one parent. The children can be associated with positive or negative numbers (rate of change). As a parent, the amount asso…
First, I would like to address that I do not know how the back end of Anaplan is built, so I am unsure as to the possibility or ease of implementation of this idea. The idea is taking a concept from S…
Hi Team, @Misbah @einas.ibrahim I am Struggling with the data not auto refreshed in Safety stock exception DB. eg. If I select FY21 page selector then it is not auto-refreshing the data and even when …
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amoun…
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at han…
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
Hi, Please can some one help me on how to do this as Department as well as Role name have same name Executive and same code Ex in them. How will data flow in to the module correctly in this case. Role…
Hello, I need to create a module in Anaplan to track the status of data loading. 1. Users are loading data using Excel Add-In. 2. Then, they need to check a checkbox (Boolean) that the data has been l…
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another…
Hi, we have requirement in our anaplan model that we need to send an notifications before due date to multiple users which belongs to different business segments .
Hello, When comparing my DEM03 Demand Forecast numbers to the Anaplan example, my Default Forecast seems off. The DAT03 Historic Volumes appear to match. Anaplan example: what I see on my DEM03 module…
Hi, My DEM03 Demand Forecast is not matching with the Check your work data. When i select All accounts for a product SKU, my data is different from the training material. I am not sure how i arrive at…
Hi, In this section Allow editing tab is greyed out for me. Am I missing something here or I need additional permissions to have this. Also this section is not visible to me. Please can someone help m…
Under INV module the JAN 20 beginning inv is matching Week 4 Beginning INV. Shouldn't the Beginning inv for a month be the same as Week 1? I keyed in some forecast values in DEM03* module. WIll this a…
