-
Level1 exam
I have no list with name All Roles but still getting error while putting it as top level in EMP 03 Role
-
Model1 Chapter 13 Price and Growth assumption Page
Please help 2 things different in my board and how to fix it 1.Margin Summary chart and Forecast periods grid have "US" and "Chocolates" in left hand corner but not in my board why? 2.My board have 2 times US mentioned in top right corner
-
Circular Reference for rollforward calc
I have a circular reference issue that I have not previously seen. The screenshot below shows a relatively simple example of a roll forward calculation where balances are carried forward. The issue I am having is that I would like the 'Out' line item to be dependent on the 'In' line item and simply take data from the 'In'…
-
Formula for Number or text
Hi, Is it possible to format a line item so users either input a number % or "n/a"? Thanks
-
Need help in setting the column
Hi Need help in setting a column up in our module. We have four separate columns , Cons_Last Month, Cons_Last Quarter, Cons_Last_Half Year, Cons_Last_Year, which are the numbers of past historical consumption quantity of a particular sku. For better presentation, we want to show all these under one column header '…
-
Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module
Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…
-
L2 Supply Chain Model DEM01 & DEM02
Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks
-
Comparing List Items
Hello All, I'm attempting to do expiration calculation on lot codes based on a few points QTY in the lot Sell by Date Days on Hand When importing the inventory, we add 1,2,3 etc... to each line and use that as the code for the list. So we import the codes into the list first, then in the module it would look something like…
-
Consolidate Numbered List table
Hi All, I needed some help in designing a consolidation table for the input table as attached as image. i am trying to consolidate the Org Var based on CF Lines,Driver,Driver Groups for the fixed dimensions (in black). If i use these dimensions (CF Lines,Driver,Driver Groups) ,the model size increases to a huge extent. The…
-
Formula - Yes, no, n/a
Hi, How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no". Thanks in advance
-
Pivot conditional formatting multiple levels - format selected columns
Hi Can anyone advise if it is possible to give conditional formatting only to the 1 of my column levels if there are multiple levels? I have the following columns: Level 1: account (sales and ebit) Level 2: scenario (act, bud, forecast, and variance to bud and forects It seems i can only filter based on account, so it…
-
Conditional Format in Total
Hello, Please help how can I apply a conditional format in my line item for total without putting a summary in the module blueprint. Please see attached picture. Thanks advance for the help. Tom
-
Level 2 Model Building/ 2.4.7 Activity
Hi, Having a hard time figuring out how to write a formula for Line Item forecast cf in Module DEM03 Demand Forecast. The instructions are below. Write a formula for the line item: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the…
-
New Best Practices article: The Importance of Building and Maintaining a Clean Model
All, Just wanted to share a new Best Practices article on The Importance of Building and Maintaining a Clean Model and please make sure you download the attachment where it answers frequently asked questions and what to look for. Link Thanks, Rob
-
Unable to Access L 2 Training
Hello, I started the L 1 training on the academy but then switched to an instructor led course for L 1. I completed the instructor led training. The L 2 training is currently grayed out, my guess is because it still shows I'm in the middle of L 1 training. Is there a way to access L 2? Thanks
-
August 2020 release
Hi Anaplan Community, Where can I find information on the flexible time labeling which has been released on August 8th 2020? Flexible time labeling: Workspace Administrators can label the models they build out by calendar year (CY) or fiscal year (FY), to better inform end users about the timeframe certain models…
-
Nested Sorting
Hello, I there a way/workaround in sorting a nested axis in Anaplan? Attached is the example module where I need to put the TOTAL LIST1 and TOTAL LIST2 at the start of each list. Thanks in advance for helping. Tom
-
Need Formula help
Hi Please refer the screen shot attached. Within a parent,I want to sequence the column 'Structure Type' based on each unique Job Name.For example, for Job Name 318317,I have marked 1 and 2 for 317542. Need to know how to setup the formula for the column 'Structure Type' for this requirement. Thanks Regards Prabakaran
-
Driver-based planning, connected to Finance app
Hey Anaplanners, I'm curious about best-practice for building connected, driver-based models. I have a an idea of how I'd do it, but not sure how others would accomplish the same objective. So, I'll present a very simple example to get the point across, with the objective of receiving feedback on how to correct / improve…
-
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…