-
LEVEL 1 MODEL EXAM
Cleared the exam but was not able to get one answer in Activity related to calculating expenses by region and role Can anyone let me know what was the correct answer or whom to contact for the same
-
Model Builder 2/- TRA01 Shipping Time in Weeks
Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By…
-
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
-
Days in Month
Hello Everyone, New model builder here. I'm trying to figure out how to display the amount of calendar days in month. I used DAYS() but it's coming back as 28 days 28 days 35 days which I presume is because we are in the 4-4-5 timescale. Is there a formula that I can use to figure out the days for a current period? In…
-
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'…
-
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…
-
Data import of different Dimension
I apologise for asking a basic question. As I have none to assist, so seeking assistance from Anaplan Community. The Source Data Module has Yearly Values. The Target Data Module will copy all the values in Weekly as well as Monthly. Please assist me, if any Document is there in Anapedia, mentioning the way out.…
-
Formula for Number or text
Hi, Is it possible to format a line item so users either input a number % or "n/a"? Thanks
-
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…
-
Filtering a module to only show non-zero entries
Hello I have a module where the rows are line items and the columns are list members. The view I am trying to create of this module is intended to be used so that we can easily identify any data that has been loaded to a combination of product, company, and GAAP/STAT incorrectly. I want to filter this view so that it will…
-
How to build Parent/Child hierarchy for different sets of children
Hi Need your help in developing a solution for this requirement. Please see the attached data sheet.We execute Jobs to make Assembly Items by consuming Comp Item numbers (Typically we consume 2 types of Comp item numbers to make one Assembly item). One Assembly item can be made in more than one way.(i.e. We can create two…
-
Anaplan usefulness over others
Hi Friends, We can perform What if analysis in Tableau. So can't we directly import data from SAP and perform better data visualization there? Tableau also can do Budgeting & Forecasting. Why do we need Anaplan in between?
-
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
-
Ranking across a dimension consisting of multiple list items
Hello, I'm trying to create a sort of 'heat map' based on percentages within columns in a table. Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting. For example, 'training period' would have 'problems with…
-
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
-
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 1 Model Building Certification Exam Issues With Updating EMP02 Formulas
Hello, I am currently in the process of completing the Level 1 Model Building Certification Exam. I've gotten to a point where I've been asked to update the EMP02 formulas for Bonus %, Car costs, Phone costs, and Medical costs to reflect the new EMP03 module. I attempted #4 and failed both times, so now I'm on #5, which…
-
Academy: Model Building Level2, sprint 3, Lesson 3.5.5 question
I have a question for Model Building Level2, sprint 3, Lesson 3.5.5 and the product SKU by Distribution Center panel on the Distribution Center Summary UX page (in My Pages). I got it working, but I want to know if there is a better solution as my screen layouts are slightly different to the prototype. I used a grid and…
-
PREVIOUSITEM() - PREVIOUS() on a list
Referring to the previous item in a list is a nightmare: You can write a lookup to find the previous item, but as soon as you try to use it you get a circular reference. Sometimes you can get round this with creative use of the CUMULATE() function on your list, but sometimes you can't and you need to map your calculation…
-
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…
-
FX Conversion Help
Hi, I currently have a list of bank accounts in various currencies. I need to convert these currencies into the product currency. I am currently converting all bank balances into GBP using a FX module and then converting all back to the product currency. However, is there another way to do this? The excel file I'm trying…
-
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
-
Duplicate Data values
Hi Friends, Q1] What do we need to do, to avoid duplicate data being entered in Data Hub? Q2] Can we write any formula in Data Hub for concatenation, to increase performance? Does Data Hub supports formula or calculation?
-
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
-
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…
-
Data Hub Optimize
Hi Friends, If the Data Hub size is huge, how can I optimize it? As it is taking a lot of time to get data imported into Modules. Regards,
-
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…
-
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
-
Formula assist
Hi, I have 2 lists: 1) LIst of Funds (P3) and 2) List of Fund entities (P4) whose Parent is P3. I also have a P3 details module that lists out the fund currency for P3 Funds. My issue is, I have a module (P4) which I'm trying to pull the fund currency from the P3 details module - i've tried using PARENT(ITEM etc, but…