Facing Issue Content Description We are facing a difficulty in splitting months from the list drop down in New Period(Quarter) into its corresponding M1, M2 …..M5 line items. STEP 1: We are selecting …
Hi, I have created a module where the user can input costs manually based on a line item formatted by Time Period (Month). They are now asking if I can hide the past months as they go forward to alway…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time…
Hi, Is it possible to lock certain versions? My customer wants to take their budget version and copy it to another version called Re-Forecast 1, and then "lock" this version in Anaplan so that no one …
Hi, My client is asking to be able to select specific FY21 months and based on the average of those 1-12 months selected populate FY22 and FY23. I have created a module without time dimension that has…
I'm trying to write a formula for picking up a amount in the Next month. Below is the formula I'm trying, but not working. Line Item[Lookup:Next()] Want to look up the amount in that Line Item for the…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time…
In Activity 5 of the model building exam, it asks to adjust formulas for EMP02 Employee Expenses module for the Bonus, Car Costs, and medical expenses to reference driver data in EMP03 Employee Driver…
Hi, I need to be able to move employees from one department to another based on a input date selected. List: L1 Department L2 Employee So the employee in L2 should in other words move to a different p…
Hi, The employee list consists of all current employees in the company and I have their salary among other informaiton in a DATA module. I have created a Salary Forecast based on FTE, Salary, Start Da…
Hi all, could you help me how best to structure a parallel hierarchy list that we need as part of our ongoing business analysis. Here's the construct that I'm looking at. At the bottom level we have C…
Hi need help on the below query. I have three line items. A, B, C where in A and B are the inputs and the C is based on the Formula. IF (PREVIOUS(C) + A + B) < 0 THEN -(PREVIOUS(C) + A + B) * 0.0386 E…
numbers will be uploaded quarterly but in YTD figure, I need to plot the quarterly numbers. Q1 YTD will be imported in Q1 and I need to save it in my Q1 column Q2 YTD will be imported in Q2 containing…
Hi , I have a model in Standard Mode, I need to create a revision tag but I see that revision tag option is disabled. Can someone suggest the possible reasons for the same as well as any workaround fo…
Hello, Can some one help me on the best practices to follow on large Ragged hierarchy in Anaplan. i know that top down allocation will not happen properly in ragged hierarchy, Apart from these is the…
Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,
Hi, I have a question for the Model 1 Building Module REV02. The mapping is incorrect for the Volumes and I'm not sure why. Please advice. Screen Shot attached. Thank you