Dear experts, I'm trying to create an Optimizer, where I'm defining the Objective, Inputs and Variable. However, I get an error "Could not parse Optimizer configuration". Is it compulsory to define th…
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All fol…
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views w…
Hi I am working on the above activity, but struggles to understand what these formulae mean in the following format (If, then, else) with the sum function in the formulae: IF 'SYS09 Version Details'.F…
Hi I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup …
Hi, I want to be sure in the Level 1 exam, the question is asked for FY even though the Employee Expenses are not based on time. So, since all Employee Expenses are given as currently values, the valu…
Attending Anaplan Live next week, in San Jose? Make sure to swing by our Customer Connect meet up, specifically geared towards Model Contributors of all levels! Our own @rob_marshall will be leading …
Currently, there is ability to add multiple items in a worksheet main view: When there are grid cards in Additional Insights, the insert multiple items option is not available: The option to be able t…
Hello everyone, I am facing a problem in counting the same names in numbered list. Let me explain with pictures, I have a numbered list :- Style. In this list, every member has different code but mult…
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after t…
I have created a saved view as required for this activity but my work is markedly different from the example provided and i have not been able to figure out why. Here is my saved view as opposed to th…
Hello, I am unsure what went wrong, but my Offset formula for FY20 is no longer populating. I had it working previously, but I don't know where I went wrong. I've been using the appropriate formula fo…
I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to fin…
Hi everyone, I have two modules, let's say M1 and M2. In M1, the dimensions are Users and Activity (List of activities). In M2, the dimensions are Styles and Time. I have made a filtered (Style filter…
Here at Anaplan, we are committed to creating a product and learning environment for everyone, which means providing tools, accessibility options, and knowledge for all people. We are fortunate to hav…
If a line item is formatted on USERS, end user should not be able to see any other USER but himself in the dropdown and they should see only one name in the dropdown. Admins on the other hand should b…
Description of the enhancement required: Disallow un-assigning items using the 'Assign' action. There's a left-arrow in the assign action that will delete an existing list item. It would be great to h…
The assign action provides a great UX for a user to assign a list item to be the numbered list child of another list. In T&Q Use Cases, this can be used to assign accounts to reps. The downside of thi…
Hi, I want to improve modele performance. I'm trying to improve IF statement. Here is two statement. Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0 Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B …
Hello All, Consider 2 General List List 1 Has A,B,C,D,E,F List 2 Has A,B,C,D,E,F And 2 module in which module 1 have dimension List 1 has value A=100, B=200. C=300, D=400, E=500, F=600 And module 2 ha…
In Level-1 under "8.8.4 Activity: Add Formulas to Size, Margin Report Module" why do we need to change the Margin % line item Summary Method setting to Formula. What is the outcome or output of this c…
Hi, I am sure I am using correct formula for calculating Beginning Inventory but my module doesnt seem to reflect that. Formula - IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PRE…
Hi, When I check the REV03 Margin Calculation Module in Level 1 Course, I see that Cost of Sales is greater than Revenue in almost all cases after Jan 20. Maybe I am doing something wrong but I think …
I have added the conditional formatting for Final Forecast, but not sure what to do for Initial Demand Forecast to make it look like the material provided screenshot. Here is the rule I have in place …
