-
8 5 3 Import Data into Volume Inputs
Hi All, I've seen a lot of different issues and answers for this activity, but I haven't found the specific one for my issue. What it should look like I got this part correct: But, the finished result is supposed to look like this and I can't figure out how to get there
-
9 2 5 5.00%
I'm confused about where I'm supposed to insert the 5.00% mentioned below
-
Modeling in Anaplan with alternative tools: Part 1
Today we are thrilled to feature Certified Master Anaplanner Mitch Aist (@maist1) in part one of a Community story on how to model build in Anaplan with alternative tools. Inclusivity and accessibility are key as we create the future of Anaplan and build solutions and experiences for all users and stakeholders. Mitch’s…
-
Data mismatch error
currently working on the level one exam and stuck on question 6 with rev04 model getting the formulas in. i know the formulas are right but the error pops up. so is there another step before entering the formula that i should be doing to bypass this error?
-
Actions working differently in different environments
I have an Process which contains 4 actions. This Process is in DEV, Test and production environment. The process works well in Prod but not in DEV and Test for the end user. No change was made with respect to the actions in DEV. Also tried setting model same as end user's role. But still its throwing error in Test and dev.…
-
Polaris Calculation Engine
Hi, Can anyone tell me why Anaplan has named their new calculation engine as "Polaris". Is there any kind of significance to the name "Polaris"? Thanks BB
-
L1M1 12.4.6 Activity: grid view (2nd part of task)
Hi everybody, wondered if anyone could help me on this as i've been stuck for some time. basically we are supposed to have our grid view look like attachment 1, however, mine looks like attachment 2 &3, i've double checked the formulas, don't have a filter on,etc and cannot figure out why the numbers don't match, as they…
-
Different output
Hi, I am following all the steps but my screenshot is different than expected, what could be the reason? My screenshot: Expected: Thanks,
-
Break Circular Reference
Hi all, I'm trying to set up a project planning model in Anaplan. As part of this setup, I'm trying to calculate the start date and end dates based on the dependencies. The logic I'm trying to build is as below, Start Date = IF ISBLANK(Dependent Step) THEN Project Start Date + Lead Time ELSE End Date(LOOKUP: Dependent…
-
Line Items' format
Hello, Even though I edited the Line Items' format, it shows nothing. I don't understand where I am doing wrong. Could you help me, please? Thanks, Mark IT SHOULD BE LIKE THAT;
-
How to identify duplicate text in lineitem to buila a unique list?
Friends, need your input and help in meeting the below scenario where I have a module n Dimension (IDs) and few listtype line items. There are repeated values if I concatenated line items (fyi in Anaplan; NAME(A) + NAME(B) + NAME (C) + NAME(D)) and need a unique list from those concatenated values. Tried RANK but can't use…
-
Planning our Modellers Forum 2022 vision!
Good morning all! So just to keep you up to speed with what is happening in the world of the UKI Modellers Forum...this morning @Paul , @ChanD and I are having a planning session to chart an exciting roadmap for the year ahead. Expect to hear from us with some future dates...and hopefully...some in person offerings at our…
-
NEXT or Previous cell values without Time dimension
Hi All, Is there any function in Anaplan, which can be used to get the next cell value from first line item in a new line item. or 2nd scenario is to ignore the prior cell values, For example: IF SL1(List item) ignore first 1 cell, for SL2 ignore first 2 cells,SL3 ignore first 3 cells ....and so on. I have done this using…
-
Lookup and use case
Hi, I am new on using Anaplan. I was looking for use of lookup between source, mapping table and target. I read below statement but could not understand properly. "If your mapping table contains the Target List and maps to a Source list-formatted line item or list-formatted property, then use LOOKUP in your formula." Does…
-
Level 1 Model Building Exam - Activity 7
I am trying to build out the UX but my data is different in some spots than what is shown in the example. Not sure what to do
-
Center of Excellence Series - Master Planning
The flavour for this year is not just about recovery but building strength in your capabilities to achieve the growth with scale you planned for, last year was unexpected, we all had big plans that might not have come to fruition, as many of our capabilities were tested. I’ve set myself the challenge this year to help the…
-
Zero Suppression
Hi, Is there an option to suppress zeroes in a module so all the cells that have 0 or blank as values can be hidden? Thanks Megha
-
Anaplan model builder level 1 exam activity 2
Hi, I am trying to update REV02 volume inputs from DATA02 SKU volume module using a formula. when I type the formula ‘DATA02 SKU Volumes’.Volume , it returns the error message that: invalid formula for REV02 Volume inputs’. Volume. Automatic sum of DATA02 SKU volumes’.volume over P3 SKU hierarchy is not possible as P3 SKU…
-
Module
Hi, I am getting Lesson 6 in the level1. Even though I followed all the instructions, my result looks different than in the example. Where did I go wrong? Please help me? Thanks! Mark My screenshots: Example's screenshot :
-
Department as a % of Total Revenue
Hi everyone, I am currently trying to develop a model that references two different regions within a list (that is production data). Let's say we have 2 line items: New England Revenue Total Company Revenue I want a ratio where I can reference our P&L (300ish line items) and say P&L Revenue [Select: List.New England] / P&L…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
When I am trying to enter the formula in REP02 Size Margin Report revenue i am getting an error like this ... (Data type mismatch: format other than LIST or DATE being referenced as a relation)
-
Movingsum over if statement based on isactualversion()
Hi all! In our model we do not get the wished results from a moving sum. I want to preform a movingsum over a line item which is constructed with an if statement in a model with versions. This is my line item if statement: Where isactualversion is iscactualversion() and is thus dependent on the version. Then we have a line…
-
About textlist Formula
Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you have any idea?
-
Information regarding the Module is used in any dashboard in the New UX
When we all had classic dashboards only, it was easy to check which module is used in which dashboard by going to the "Used in dashboard" column. However, as most of us are using new UX now, the column "Used in dashboard" has become futile. Also, we don't have information whether any particular module is being published in…
-
modules width adjustment
The module name will be cut off, so please be able to adjust the width of the column.
-
Level 1 Model Building Exam Model Building Activity 5 correct sequence
-
Level 1 Exam question 7 (should the answer be rounded?)
Hi, In response to question 7: What was the total expense for the FY21 executive bonuses in the Americas? the total equals XX.999999999996 do I have to round up? Thank you
-
Can I use the TimeSum with SELECT
Hello Could you help me with the following case please. I have a formula that is using SELECT but in addition to that I need to add a sum controlled by months with some members that I have already created but when using the timesum it generates an error because it conflicts with the SELECT. How could I solve it? The…
-
Spring refresh — Anaplan edition
As you consider the areas in need of a spring refresh in your home or office, it is also a great time to do the same for your Anaplan models. The most difficult part about cleaning is figuring out where to start and selecting the tools and equipment needed to get to the finish line. Let’s break it down into three…
-
Using Delete from List using selection for partial deletion of data for current Month only!!
Dear Community, Needed to check whether is it possible to delete Monthly data using Delete from List using selection for that particular current month. For example if we have data from Jan 2022 to Apr 2022 but we need to delete only the data for month of Apr 2022. How can this action be modified since we can currently…