-
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…
-
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…
-
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
-
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…
-
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…
-
Line item formatting
Hi, Question please. Would like to ask if it is possible to have two formatting in one line item? for example (see ss below), the columns are line items and the rows are LIS. The GLA for 2018A and 2019B (9% & -3%) are percentage change variance while the Lease out rate formula is the difference of 2018A and 2019B (4p%ts &…
-
Formula error - dimension issue
Hi, Can someone assist with a formula error I'm receiving? I currently have 3 modules (see attached), and in the third module, I'm trying to calculate the number of meetings by entity and product. The error message I receive is: Dimension of mapping used for aggregation doesn't match any dimension of the source. My formula…
-
what is Hyper Model?
I read this news. https://community.anaplan.com/t5/Releases/Anaplan-HyperModel-Model-complex-problems-at-scale-and-adapt-to/ba-p/77929 In this article, many people comment that we can get more workspace 130GB to 700GB in Hyper Model. I don't understand what is Hyper Model. If we want to use Hyper Model, we have to pay…
-
Ratio formatting
Hi, Question please. I am trying to format the percentage change (in red box) with suffix of "pts" but when I click the percentage the suffix is disabled. I tried also using the Ratio in the Summary Method but still the same. How can I fix it? Thank you.
-
Best way to handle validity of products prices
Hello Anaplan community, I'd like to create a model that stores prices for my items, and the evolution of these prices. A few constraints though: * Prices can evolve with time, and the applicable price at one date can be different from the applicable price at another date. * Products don't change prices at the same time,…
-
Optimiser Time out error
Hi, I am running an optimizer with Time out limit of 20000 seconds.However post 60 mins it throws the following error: "The solver was cancelled due to timeout, please increase the solver timeout value to solve the problem" Does Anaplan has the limitation of only 60 minutes? Not sure what is the issue. Can anyone please…
-
DELETE DRAW PAYMENTS FOR AT JULY AND AUGUST
Hi. Dear Anaplan community. I am new here. I got something to solve and would like to ask for help. In ANAPLAN, there are set up automatic draw payments for Austria AT. This logic, was called off by the end of Q1. In the sales statement report, filtering the Austria AT, my colleague still see Draws for July and August. Who…
-
To build formula which is like PREVIOUS() but references a list item instead of time
Hi All, found out a work around for this, until Anaplan creates an in built function to fetch previous or next values in a list, without referring to Time dimension. Hope this helps Link to Anaplan Idea Exchange: https://community.anaplan.com/t5/Idea-Exchange/PREVIOUSITEM-formula-which-is-like-PREVIOUS-but-refer... Other…
-
User Access Issue - Cannot insert without a parent
Hi, There are two lists: A (parent) and B (child). List A has selective access turned on. Now, one of the users is not able to load items into the list B without a parent even with the proper access to the parent list. They are able to load only with Workspace Admin access. Attached is the error that the user received.…
-
How can I map these two dimension ?
I am writing formula for growth percentage where time dimension in weeks, and having product family as a list i.e. Product SKU's. In source module I have product family AS a dimension, where product SKU is third level of product family hierarchy. How can I map these two dimension ?
-
Numbered List update
Hi, I have a numbered list A with list items. These list items are getting imported through action from some other list B. I need to rename the list items of B and want the same renamed items to get imported to list A. When I rename the list B items and run the Import action, new list items A are getting created with new…
-
Clear Module Data
Hi I need to clear data for all 5 level(5 Numbered lists) using single import.Individually i have created clear actions at each level and it is working but I needed it to be done at top level i.e if i clear at top level all the data at child level should also be cleared.Any suggestions to clear at Top Level. Thanks SriNitya
-
Planual Explained - Day 38
"Rule 1.06-03": Article 1, Chapter 6, and Rule 3” Avoid single item subsets If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members Here is how it was done in Pre Planual Era. We used to create a subset which includes/houses just a single list…