-
Determining A Line Item By Reference to Other Line Items
Hi all, I'm trying to do something that I think SHOULD work but I can't get it quite straight in my head so I'd appreciate some support. I've got a module that's holding employee data, dimensioned by Employee ID and by month. I need to be able to identify people managers, but the data extract doesn't have a flag for that.…
-
New Modelling Experience
There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS),…
-
how to add module
Hi All, I got access to the anaplan but my home page doesnt show anything even i am unable to add a new module as there is no option showing. Pl help. Regds, Chetan
-
Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
Hello Community! Is there a way to calculate the number of complete months between two dates in Anaplan? E.g. Start Date (MM/DD/YYYY)End Date (MM/DD/YYYY)Number of Complete Months07/17/202007/16/20211212/03/202103/31/2022310/1/202112/31/20213 In the second row, even though the duration between 12/03/2021 & 03/31/2022 is 3…
-
How to find monthly average of Daily Totals?
I want to create the average of every month of a LI that displays Daily totals. One of the LI's will be my total account balances on a daily bases, and then I would want to create another LI that would show me the average of those daily total for each month. How would I go about this? Thank you
-
LOOKUP function with a version module
Hello all, I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function : previous Fcst = Fcst Qty[LOOKUP: Param Version.Previous Version], Param Version is a system module that manages versions. It seems to…
-
Dynamic ranking not working
Hi Community, I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working. However, when I remove "group by" condition from rank formula, it ranks. Why is it so? Can somebody explain please? Thanks Alka
-
Understanding data referencing in Anaplan
Hello All, I am unable to understand how Anaplan is using data referencing. Please see the below scenario. I have to create a system module with product SKU details. I am using SKU Flat list as dimension and Code,Products and Distribution Center as Line item. I have imported the data from a CSV file and it looks like this.…
-
2.3.10 Activity: Create Demand Forecast
Plz can someone let me know are these formulas correct to go further in the assignment
-
Start function returning start of the week when I pass a Month period as a parameter
When I apply the Start function below against a Month period it returns the week period start instead of the start of the month for the month period. The calendar setting has calendar type set as week which I guess is the reason it's returning the start of the week. Is there an easy way or another function to that will…
-
Mapping Data from one module to another
Hi Everyone, Please consider following example, NameTypeAZPBRBZRBRCZRCLDZWIR I have a module A with 'Name" as list and a line item named type as shown above, now below I have a second module B with a List "Class" and the list "Name" in module A is a line item here. ClassName TypeABDA SHGB AJSC How can I bring the values in…
-
why DCA for formula based line item?
Hi All, Downloaded the DCA App from App Hub and looking through the examples. Have a question in regard to below screenshot, 2 lines in module, both have formula which means no user input and in effect read only, and yet DCA read write has been set up, what is the purpose? not clear. Anyway user can't input since populated…
-
Level 1 Model Building Exam Activtiy 5 -- unable to calculate right formulas
Hi, Can anyone please suggest to me what is the mistake I'm making here? Q:
-
2.3.9.1 Import data into DAT03 Historic Volumes module
hi in this run process in getting as below picture. Can u help in this
-
General Questions
Hello, I currently try to take a Anaplan lvl 1 Model building class and I don't have any accessibility to Anaplan system(Current company doesn't use). I applied for 90 days trials(I read that I need this) and Anaplan activated my account for access. From this point, I don't know how to start my course, can I start my…
-
Abnormal behaviour of Actions
Hi Anaplanners ! Is Anaplan facing issues in the Action Mappings? I had renamed few line items(eg: Line Item A renamed to Line Item B) in the model, and tried to test the actions, but none of them worked. When i checked the mapping of the actions, what i saw is really strange. I saw two line items (Line Item A and Line…
-
New Modeling Experience Quick Edit in Formula Editor
To all the Model Builders and SAs using the New Modeling Experience - we have a new feature that just dropped today. We have just switched on a new formula editor feature to help you quickly enter edit mode if you have edit permissions. How it works You can kick off edit mode by: * Double click (left mouse button) in the…
-
not recognised as a hierarchy
Hi getting below message when I try to add formula to code as per 6.8.2 Activity .
-
Spare Anaplan Talent Builder Account
Hi all - I am trying to learn Anaplan and am currently on L1 model building training. It says to "Click to download a copy of the Level 1 Model Building 2.0 (New UX) model" but I am unable to do so because Anaplan requires a separate account from Anaplan Community. Since I am not currently with a company, I have to use an…
-
Values not being displayed in the TAR01 Detailed Sales Target module.
Hi, I am unable to view the values even after entering the formulas in the TAR01 module. The dimensions are quarterly but no value is being displayed in any format. Please refer the screenshots attached below. Please help in this anyone. Regards,
-
SYS05 Region not populating with Region List
Hi, The 'Region list' is populated but still the 'SYS05' code line item is not populating with the region code. What can be the issue. I have not made any changes to the 'SYS05' module. Screenshots attached. Pls guide.
-
level 3 tar01 - initial acc sales target
Hi clarificiation - I used 'TAR00 Sales Targets'.Initial Country Sales Target * 'PY Account / PY Country Product Family' I see these results the total for candygate relates to learning center screen : the problem is the formula totals everything for all accounts; so i feel it is incorrect and requires an edit - lookup ‘PY…
-
Mailto Limitation
Anaplanners, I have created a mailto logic which is pretty comprehensive which has around 10 questions and each question has about 2 lines in it. But the number of characters come around 600, i'm using quote remover logic to para-space each questions. I'm also using some line items to get results for some of the questions…
-
FINDITEM of first 3 character in List
Hi, I have a module with say a Product dimension consisting of 3 Letter product codes, e.g. APP, ORG, PEA. I would like to find these items in a list where the Names in the List are 5 Letters e.g. APPUS, ORGUS, PEAUS. How am I able to lookup APP against the list of APPUS (first 3 letter) and return ÀPPUS?
-
New User
Hi All, I am logistics professional and i want to learn the Anaplan and need your guidance to start the journey. pl help. Regds, Chetan pophale
-
Find a list member based on boolean check
I have a scenario module dimensioned by scenario. And a line item formatted as boolean. Based on the selected boolean check, the corresponding scenario should appear in a 'scenario' formatted line item in a module with no dimensions
-
Getting Error "format of mapping used for lookup doenst match any dimension of the source" no clue
I have a source module dimensioned by tmpSalesTerritory list, that is a numbered list Need to get “final_segment_country” and put it in this module below on yellow marked The problem is when I lookup the value from property module I received the msg below… Can you help me to understand what is happening? Since I getting…
-
FIND Function
Hi Team, I'm using the FIND function for the 1st time & it not working as I expected. It seems like a basic Function so I must be missing something easy but I would assume that below the value returned in the FIND line item would be 1 as it would find ANZ? Thanks
-
Calculate MOVINGSUM from module with no time to module with time
Hi there, I need to reference a source module line item with time to a target module line item without time to achieve an Actuals Rolling [6, 12, 28, 24 months] SUM using MOVINGSUM. In this case, it would be the sum of the previous 6 months from Jan 22. Please see attached screenshots and let me know if I can provide any…
-
Number Import
Dear Community, I am importing 1.000- into a numbered format line item, system is recognizing it as 1000. Any reasons, why it is happening and how can we overcome it? Thanks & Regards Badam