-
Model
i want to learn level 3 can u please share link of the course with me . i am not able find that course
-
Last day of month for line item
Hi, How do I get the last day of the month for a given line item when the module is dimensioned by Time? Please help. I need the last day of the month for the line item in the screen shot.
-
Comparing text formatted line items
Hi Team I am having a module with two line items(Error 1, Error 2). I need boolean to be checked if the texts in two line items are not same and it should retrieve the text which is not same in another line item. ListError 1Error 2BooleanOutputProduct 1Text 1,Text 4Text 1,Text 4FALSE Product 2Text 1,Text 4Text 4,Text…
-
Issue with formula editor getting worse
Hello All, A couple of months ago I called out an issue (confirmed to be a known issue by Anaplan support) about the formula editor in the new modeling experience. You could not reference a list item by clicking, you had to type the entire reference.…
-
Timesum with Date
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
When i am running the process as described * Run Process 9 Import Data from the Hub. I am getting error as Any help will be appreciated.
-
How to pull property data in line item
Hi, I have module with two lists and in that module for one line item i need to pull data from one of the List's property. for example: i have Employee list with its property as "Position" and i have module with Employee & Product as List and i have Line item as Position. So i need to pull Position of all employees in that…
-
Help needed: formula is invalid
Hi, My name is Usha Priya. I am trying to add formulas to the SYS01 Time Settings by Year System module. I get a message saying the formula is invalid. Please find below the screenshot. I need some help to solve this issue. Thanks.
-
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
-
Sprint 2 Activity 2.3.9.1
I’m really stumped here on this activity and can figure out where I went wrong. Could someone assist.
-
Need Help: Circular Reference Error
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below to showcase the original formula, the formula that give me circular reference error and the backup formula. Recently, to…
-
Anaplan Time Days Mapping with Custom Days List
Hi, I have created a module to map Anaplan days with Custom Days List (snapshot attached). But while I am trying to use the Custom list in Sum formula it is not giving any value. Time settings at my end are at week Level (4-4-5). I have build this mapping because while aggregating days into months gives wrong summation due…
-
Issue with formula editor :clicking on a list or list item does not work anymore (e.g. for finditem)
Hello All, Since the new formula editor release, I noticed that when I am editing a formula and go and click on a list or list item, the formula does not get populated with the list / list item. Now instead, I need to type the name of the list (e.g. when using FINDITEM or ITEM formula). This is bad! Is anyone else having…
-
Selecting Lists from General Lists in New Modelling Environment
Hi, I am little late to the party regarding the new modelling environment. However, I have started to use it and the experience seems to be very posititve. However, I have been unable to directly reference lists from general lists when requiring them in a formula. I am finding that when trying to reference a list directly…
-
Level 2 - Sprint 1 - 1.7.3.2 Import into SYS08 SKU Details module
Hi , I am trying to import the details Level 2 - Sprint 1 : 1.7.3 Activity: Import from Data Hub to Supply Chain Model 1.7.3.2 Import into SYS08 SKU Details module Use the saved view from the Data Hub model to import into the Supply Chain model SYS08 SKU Details module. My mappings Import has been completed but with errors…
-
SUM & LOOKUP
Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options - * I tried with…
-
Formulas in lesson 6 not working
@noelle_murphy Hi, can I set up a 1:1 with you? Some of my formulas in lesson 6 aren’t working & it’s hard to move on from that. I also sent you an email. Thank you
-
Hierarchy Summary
Anplanners, I have a Module (XYZ) Dimensioned by GL (Row Headers), Cost Centers L3 as selectors and few Line items to determine the total amount. Aim is to get input at GL level for each Cost Center. I have a summary module (ABC) which is NOT dimensioned by any LISTS and simply has to take the high level total of the above…
-
Ways to identify duplicates for list import other than RANK or ISFIRSTOCCURRENCE?
Just wondering is there a way to find duplicates where the cell count is more than 50 million and I know in Polaris engine it is possible. Any other way to do it in the classic engine ?
-
Rollup and SUM with own value
Friends, need help & suggestion in achieving the below Above table clearly shows the Parent and Child combination but the catch is to consider own cost and child to show the rollup.. We have discovered a long method by introducing multiple line items (10 bare minimum; since the depth may be of 10 levels) but looking for…
-
Select formula
How would you use a select formula to collect totals for For example I want to fill the base opex row with numbers from this module below (totals only) What formula would I use? Thanks
-
Level 2 Conclusion: Export Comparrison
Good Day, Quick question... At the end of the INV01 Export, it says: After completing the export file, the .csv file should look like this: How close should it be? Mine: Yours I just don't know how they get the List field name in the upper Left corner, and the dates on the second row..?? Thoughts? Thanks again!
-
error code: 6.9.2 Add Formulas to Product Family Details Module
error code received and i dont know why i entered CODE(ITEM('P1 Product Family')) received this message: 'P1 Product Family is not recognized as a hierarchy in the model The ITEM function should take a hierarchy as argument
-
6.9.2 Add Formulas to Product Family Details Module
I am getting an error message when I enter the formula for SYS05, anyone know where I might have made a mistake? Preview attachment IMG_20201103_212332857.jpg IMG_20201103_212332857.jpg833 KB
-
Level 1 Model Building Exam - Model Building Activity 6
Hello All, I've used the SUM function to map region and role into 'EMP02 Employee Expenses'. I've been going through my formula and the source modules for quite some time now yet the formulas still yield 0s. Hope someone can help.
-
Filter by Property
Hi, I have a question about filter function. I have two tables. First one shows amount by Location-Product List. The Second shows amount by Product List. Location-Product List has Product List as Properties. I want to display these tables in one UX Dashboard. Then I want to filter the second table(Product) by First…
-
Modelling.
.
-
How do I get the characters before a specific character?
Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line item is formatted as text. What would be the formula to return just "JonSmith" in alias line item? I seem to get an error due…
-
Level 2 Sprint 1 1.3.10.3 Import Data into G3 Location List
Having trouble importing from a saved model. I've searched through the community for answers but still stuck. Can't seem to figure out how to get the column with the Boolean list. This is the activity and the end result: This is what mine looks like and the error I'm getting: Any help would be appreciated.
-
RE 3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi @einas.ibrahim, Instructions provided in Activity '3.3.7.2 Add DCA to INV01 Inventory Ordering' seems confusing as both line saying that result show when Submit Purchase Order Request is NOT checked and checked. I think it could be no results when Submit Purchase Order Request is NOT checked and show result when checked…
