-
L@ Model Building UX pg's
Hi, Not Understanding how to choose which Context Selectors levels are needed for certain List. It is on the Exam and I have watch the recommended videos and just need more explanation. Thank you
-
In module to check if user have selective access on the list members
Hi Team, I need to create a module in which I have a Boolean line item and applied lists are User list and a list in which I have given selective access to users. I need to mark the line item true if the user have access(read or write) on the list item else false in the module. Could you please suggest any solution for…
-
micro lessons -how to enlarge print where you are able to see...print is too small
There's no way you can see micro lessons charts...help!
-
why can't we search or filter for models in the App area anymore? Looking for a Docusign demo model.
why can't we search or filter for models in the App area anymore? Looking for a Docusign demo model.
-
Collect with Sum - An Error has occured on the server
Hi, I got a collect with sum problem. Source module (Before creating the line item for Collect): Dimensions: Time, Department Line item: Cost1, Cost2 (Number format) Target module: Dimensions: Time, Department, Charter of Accounts Line item: Cost (Number format) In order to get the costs from the source module I've created…
-
How to get the value from the source without time dimension
Hi, question please. I am doing a test variance module between line items of IC Run, Actual and Forecast using LIS, Versions and Project as my dimensions. I need to get the value of IC run, however, the module does not have time dimension in compare with my module data for the actuals and latest budget (forecast). I used…
-
rounding up in Anaplan
How do I make a Line Item round up its numbers in Anaplan? Thank you
-
Best way to identify unique text across 9 repeating text line items across and count
Hi Community! I am currently exploring the best way to identify unique text and count the unique text matches across 9 text line items by one line item that counts based on unique names: It would possible with a monster of a formula using multiple IFs but this not necessarily best practice. For example if I have line…
-
Using Optimizer for production line allocation
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. * If the production priority for a SKU is 1…
-
quarterly snapshot
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 both Q1 and Q2 numbers, I need to retain the Q1 above and get the number/result for Q2. By this time, columns for Q1 and Q2…
-
How to pick up my previous day not including weekends
Hi, I would like to some advice on how I can pick up my previous day not including weekends. Ex) My previous day for Monday would be Friday. This is the Formula I tried to use below. I have a Time Filter Line Item that marks 0 for any weekday and 1 and 2 for weekends, so I can try and only pick up the 0's. Below is my…
-
Building Question
Hi, I'm trying to make a unction that takes my ending balance at the end of the month and moves it to another line item. This is what I tried but totally did not work, need some advice. Thank you 'S01 Time Filter'.End of the Month[select:'Securitization Master Acct (x5000 Closing)']
-
Time Setting Weeks
Hi, How can I limit the weeks to fall to its month only? In my screenshot, my Wk35 Aug 30 falls to the month of September. Regards, Tom
-
Assign Action
What Happen with code of child list when we assign list item to Parent using assign action?
-
Past model building sessions
Where can I find the recorded past session?
-
Splitting of list elements from list into line items
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 the length of the period from New Period(Quarter) line item say 3 months. STEP 2: After selecting the New Period(Quarter)…
-
Anaplan Live! is this week! Join us December 9, 2020 for this LIVE event.
Boost Your Model Building Expertise Through Interactive Sessions At Anaplan Live! Register now! Designed with model builders, end users, and even new learners in mind, the event lets attendees interact in real-time with presenters and fellow Anaplanners. Join us on December 9 from 10:00 a.m. to 1:30 p.m. CST. What's on the…
-
Formula for next month amount
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 Next month. This formula is not working. Thank you
-
Level 1 Model Exam Activity 5
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 Drivers by Role module. I have no idea what that means, can you help me?
-
Top-Down Allocations
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 Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
-
Would like to know how to make buttons on a Dashboard
Hi, I'm trying to create a Dashboard based off one of my Models in Excel and would like to know how to make them button like I have in my Excel Model (Image is attached for ex). I do not want them to be page selectors on my Dashboard. Thank you
-
Lock Versions
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 can change it. The problem as I see it is that I have plenty of modules that have versions and should be editable. Best…
-
Long Range Planning based on specific months from FY
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 apart from the "Cost Input" numbered list the following line items: Start (format Month) End (format Month) No. of Months…
-
Historical Snapshotting
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 to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…
-
Year To Date (YTD) summary column not showing data
Hi Experts, I created one module, in which I added Time Range i.e FY 18, Number of Periods = 1, and Aggregation as Year To Date. For testing purpose, I added some data in some periods. I can see total amount under FY18 (Summary column), but no data appearing under YTD column. Please let me know, if I have missed anything.…
-
Employee needs to get a new salary on specific date in Salary Forecast Model
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 Date and End Date. The client wants to be able to select a certain date for a new salary. Is the most convenient way to get…
-
How to get a Formula to output a text.
Hi, Not sure what the Synthax is for a Formula to return a text is. I have my Line Item formatted as Text, but want to know if I'm on the right track with the formula. IF 'Y01 Collection_Funding'.Front Book=1 THEN &"WITH PH"& ELSE &"WITHOUT PH" Thank you
-
Move list item to new list hierarchy based on date trigger
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 parent, L1 Department, on the date that is selected. Is the best way to go to create boolean IF date passed then import same…
-
How to get the FY19 and the FY20 values in the same Line Item.
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 ELSE (PREVIOUS(C) + A + B) * 0.0386 The Function previous gives the value of the previous month. But I want the value of FY19…
-
Parallel hierarchical lists
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 Clients that we need to be able to aggregate by different attributes. These attributes are: Client: Client 1, Client 2.....…