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 poss…
Can we have a subset of Versions so that whenever needed, we can use single version member in the modules? Currently I can think of one use case when we have to drive opening & closing of periods for …
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…
Dear Experts, I basically want to Reset Serial Numbers in Ascending Order using Rank Formula from the last number (from one module) and start over with the next number (in another module), for example…
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 Fil…
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…
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 interac…
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…
Description: As a model builder, there are plenty of times where formulas or references to other modules are incorrect either by mistake/typo or due to lack of understanding formula syntax. Based on o…
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…
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, 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 …
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…
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…
I think it would be a better option to have as a model builder. Currently, Isfirstoccurrence deals with Case-Sensitive data as separate occurrences for eg. NA and na would both be seen as separate occ…
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…
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…
At present we can publish all other actions to UX except for Export Actions, without creating a process button. It would be nice to publish the export action without having to create a process button.…
It would be nice to have the subsets updated dynamically using a formula driven boolean linking to the subsets as a formula, just like how we have the option to link Display Name to a formula in a mod…
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'.Fron…
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…
It would be nice to have a functionality which can generate code / auto-populate code, just like how a display name is populated. A property, specifying the code attribute could be useful and reduce t…
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…
Currently, when you duplicate a page, the new page appears as already published. The ability to duplicate a page as DRAFT will allow the help builders to be able to easily use existing page as startin…
When I am trying to import data into model from data hub, I am getting this "Model object 'module name'.'export' could not be located. I checked in model, everything looks good. Suggestions??
