-
level 1, 11.3.4
Hi, In model building level 1, while doing activity 11.3.4, I a not being able to correctly put the formula. I checked spellings and everything, and all looked good, but still it says invalid, or line item not found. Kindly look at the screenshots attached and let me know.
-
Employees in 2 Departments
Hi everyone, I am trying to solve an issue we currently have. We have multiple departments within our company, and we are implementing a new department, Department X. There are multiple employees who are in departments other than Department X but will be helping, and we wanted to allocate part of their salary to that…
-
Need help in creating correct Formula to get Employee expenses by Roles and Department
I assumed, I have created a formula using LOOKUP to get correct value in Employee expenses module however the outcome is incorrect when I am answering the questions related to it. Hence I believe my formula is incorrect. Not sure if someone having expertise on this can guide me to build a correct module here. Thank You…
-
Evenly Spread Amounts
Hello- We have two modules one for planning miscellaneous revenue and other for planning for OTPS. When a user enters an amount in the FY21 column the amount is not spreading evening for the forecast period. The forecast period is 6 months. Please see the attachment. I am not sure what I need to do to fix this.
-
L1MB Activity 5
Hi Team, Looking for some guidance on L1MB Activity 5. I built the following code: IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0 But get the following error message: "Automatic sum of 'EMPO3 Employee Drivers By…
-
How to get the first year from a Boolean
hi! I want to get a year. If there is a Boolean value at the beginning throughout the year, we get the year How do i do? Please help me!
-
max date
Hi Anaplan expert, The module below has a numbered list and some line items. The formula on the Max Date field is Date[MAX: Date]. I didn't get any results. Could you please tell me how the formula to get the max date from the Date field is? Regards,
-
Logics can be used for repetitive Users
Hi I am having a module with Products list as dimension and Users(Default Users formatted), Status and Boolean(Target Line item) as line items. I need Boolean to be checked for the Products wherever Users are same and Status is Inactive. UsersStatusBooleanproduct1User AActive Product2User AInactiveTRUEproduct3User…
-
Level 1 Model Building Exam Model Building Activity 6
I need a little help figuring out why I’m getting the the message pictured when entering my formulas.
-
Get Last data in all time
Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7Num1111111Offset(Num,1,0)1111110Last day 2021/1/7 I can get last day in Module A. But I couldn't get in Module B( has no time, has Product List) Module B ProductLast…
-
SUM Function and List ALL
I want to aggregate the order From Table A to B. Table A RegionProductamountax100 y10bx200 y20 Table B Regionaggregatex300y30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could not calculate it. If I have RegionALL as Region's top level of item, I could calculate it. We should use Top level of item…
-
Which aggregate function is good at performance
Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can also use "Fristnonblank" and so on because Date Lineitem is common in module. Which Formula is good at performance? Each…
-
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…
-
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,…
-
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,…
-
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…
-
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…
-
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
-
2.3.9 Level 2 - Sprint 2 Import into DAT03 Historic Volumes using actions
For 2.3.9.1 nothing is populating whenever I run Process 9 Import Data from the Hub. I didn't even get an error as most did, it's just zeros. My data hub numbers are there but nothing happens.
-
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…
-
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…
-
Lesson 9.2.5
Hi. I'm on 9.2.5 and my number isn't formatted correctly even though I'm using the parameters from the lesson. Any suggestions
-
7.2.1 Activity: Having A hard time
I've been having trouble understanding the concept of mapping and how certain values are supposed to be categorized together. If anyone can help me get beyond this error message that would be great. I feel like I did something structurally wrong before getting to this point. Took a few screen shots. I've been at it for…