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 mon…
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 sepa…
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
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, Phon…
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 w…
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…
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…
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 qu…
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 fo…
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…
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 b…
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 …
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 p…
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…
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 mod…
Hi, I currently have a hierarchy with 4 levels (non-numbered lists). In our official hierarchy, levels 3 & 4 can have the same name, so we append a L4 to those particular items in Anaplan. Recently, I…
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 201…
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…
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 workspa…
Currently we have to build a seperate conditional formatting rule for each line item. It would be useful to be able to set a rule up and then apply it to multiple line items in a module
Hi, I would like an enhancement made where, similar to Excel, when I highlight a series of cells with numbers in a column or row or both, I want a Total, Count, and Average to appear in the bottom rig…
Hi Anaplan, The New UX does not currently support a multi-lingual interface. Many of our clients are asking for this to be implemented. It would be really beneficial for many Anaplan Users across the …
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 M…
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 pric…
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 valu…
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 t…
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 Id…
Description of the enhancement required: Raise limit on RANK function while maintaining adequate performance. How would it help your business process: We've been seeing more incidents where customers…
