Modeling

SPREAD Function
Hello Everyone. I am Using SPREAD Function on Monthly Time range. I want to Spread value of only one Single Column. i have used boolean and if else condition for that but not getting it. Spread Function is adjusting All column values. and I want to spread value of only one column.
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
Suggestions on how to re-model a module
Hi, I currently have a Debt Reporting module in Anaplan which is built on the list P6 Bank Loans. How it flows is P3 Products > P4 Fund Entities > P6 Bank Loans. So within certain products, there may be several bank loans under the same facility. What would be the best way to report under Facility, rather than Bank Loans?…
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.…
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
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

Modeling

Discussion List