-
comparing list items and changing value
Hi, In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value if two list items has same type and status as inactive then change value for inactive list item should get active list item value EX: valueTypeStatusChange…
-
SYS08 Employee Details Import Issue
Hello everyone, I am struggling to get it right. Could anyone help? Here are the snapshots. I have added all of the snapshots for your information.
-
Many to Many Sum in a single step?
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging' line item that bloats the model. As the title says, I have a 'Many to Many' relationship - a single Deal can be tagged to…
-
Isolating Top Level Parent in a Boolean
I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see. I have a hierarchy as follows: Top Level = Total Company BU L1 parent = Total Company BU L2 parent = BU L1 In a boolean line item dimensioned by BU L2, I've tried a million ways to try and get the "Total Company" box to…
-
FINDITEM formula gives blanks whereas I expect values
Hi Anaplan Community, I have a strange behaviour in Anaplan. I use finditem in 4 different line items (Site 1, Site 2, Site 3 and Site 4) . The finditem formula is similar for each line item, it just refers to another text-formatted line item to perform the finditem. The result of the Site 1 formula looks good. However,…
-
indention and Summary using LIS
Hi Community, I would like to ask question, since I have not encountered this matter before. Below is a sample report with indention and Summary style. In this sample report, the items on the row are all Line items. For example the list below is a line item subset. Will I still be able to have indention if I am using an…
-
Holiday Time Filter
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the Formula for this. I need to Eliminate the following Holidays (New Years Day, MLK Day, Memorial Day, Labor Day, Thanksgiving,…
-
Leve 2 Model Building Sprint 3
Hello all, I am stuck here for more than 4 hours trying to figure out why my numbers are different but unsuccessful. Can you please help advise? Mine: Anaplan's Much appreciated!! Daisy
-
Anaplan Roll up for Text Fields
Hello, Requirement :- The parent should have the average color of its children. I have an Indicator(Red , Yellow, Green) coming as a Text input from the Source. The requirement is to roll up to its immediate parent and its final parent subsequently based on the average color as per the children hierarchy. Kindly let me…
-
List Item Not Being Created
Hopefully someone can shed some light on why the following isn't working. I've a four dimensioned module that's used to create a numbered list under one of the four dimensions. To make further downstream calculations easier to manage and to improve sparsity only those items that have a value against them are being created.…
-
7.1.1 Data Import Methods
Hi Everyone, I am done with Lessons 1 - 6. I have just started Lesson 7 and I received the Notification of collaboration. I don't know with whom and how I can collaborate? I am lagging behind but I am catching up.
-
11.3.4: Shipping costs Formula error
Hi, I need help for the formula error occurring in Shipping costs. Please find the screenshot for reference. Thank you Gourav
-
Level 1 EXAM ACTIVITY 2
I keep getting this same error message every time I enter a formula. I'm not sure if I'm entering the formula wrong, but can someone help me?
-
Previous on Custom Date
Hi Team, Assuming the Model's requirement is a monthly time dimension. However, the Cashflow Forecast requires input for every 7 days, or weekly set up. Is there a way for the previous date ending cash to be roll forwarded to the next date's beginning balance like this illustration below since I cannot use my previous, lag…
-
List and Modules
is the "applies to" column within the modules view indicative of what lists are part of that module? Also, is there another way to tell what lists make up the modules?
-
Delete message in new UX
Hi, I tried run delete action in new UX. But there are no message, so I can't count how many items I deleted. I saw it in classic Dashboard.
-
L1MB 9.2.5
trying to put in the formula's but keep getting an error message. Tried looking for answers but nothing seems to be working
-
activity 8.5.2 problem
hello, I am working on activity 8.5.2.Mapping options that I have is above. In this condition I have wrong results. i can not determine what I did wrong. it should look like this I tried to work on current selection that I have but US total # calculation is wrong... thank you Elcin
-
Lesson 8.2.1 Adding dropbox for the products
I've followed the instructions as stated in the lesson and this is my result. How do I allow the forecast to show the different products? Anyone who can help would be greatly appreciated. My model is the one without the dropdown showing nutzo bar
-
Lesson 6.11.2
I am having issues with this part of the lesson. My model does not match the sample screenshot even after several retrials. Please assist.
-
What if versions
Hello We have multiple versions in our model (ie Global 1, Global 2 etc). We created the module where user can pick the versions from the list that was created (please see the image below) and the list was named as "Model Versions" . The idea is to pick two versions and to compare it. In order to pull the data for example…
-
9.2.5 Activity: 5.0% not carried forward
Hi, Need help for 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module It was said to enter 5.00% for the FY19 Unit Cost % in REV04 Price Growth Rates module, but it hasn't carried forward to the Unit Cost% for FY19 in REV05 Price Growth Rates Staging module. Please refer the screenshot for reference. - Gourav
-
L2 Sprint 3 Shipping Method Formula
Good day, Currently I work on a sprint 3 and stuck for a long while on a Shipping Method formula. I went to Anaplan Community and found out that somehow I skipping the line item "Supplied by" in a module SYS08 SKU Details. I add lost item, run all the processes in the Action Tab and nothing happens! Can someone advise me…
-
Lesson 10.2.2 shared cost
Hello. I noticed my shared cost values are higher than the model example, but the other values are the same. Any ideas why?
-
Having Trouble Populating my LI G2 Country
Hi, I do not know why my G2 Country will not display the Country names in my G2 List. Please advise I have trouble shooting by adding a properties to help display the names and then calling upon that in my formula and that will not work, also I tried calling upon the Code and that doesn't work either. Please advise. G2…
-
Lesson 6.6.1 through 4
Lesson 6.6.1 through 4, my screen does not match with the one shown on the lesson, please help me.
-
Day Calculation for Working Hours
Task: Calculate the total monthly working hours for FTE's; new employees should be prorated based on their start date, employees that are leaving should be prorated based on their exit date. All absences outside the contracted allowance should be reduced from the total FTE Percentage, starting at 100%. Dimensionalize a…
-
SYS03 Account Product Details (L3), Cant populate LI P2 Product
Hi, I have been trying to trouble shoot populating my P2 Product LI in the SYS03 Account>Product Details Module. I have the LI formatted as a List for the P2 Product List and using the formula FINDITEM('P2 Product', ID), which will bring in the ID associated with items in my P2 Product List. I do not know what I'm doing…
-
Sum and Lookup using 2 mapping tables
Hi All, I currently have a module with 2 lists with data that need to be in another P&L list via 2 mapping tables using a methodology. Source Data dimensions: List 1, List 2, Time: Month Target P&L dimensions: P&L List, Time: Quarter This is the methodology: * If List 1 Mapping Table.Methodology = Methodology List 1 then I…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
I am getting this error during running the process 9 import data from hub. can anyone help me to resolve this error. Thanks, Aniket