Need suggestions on how to build the logic in Anaplan to solve the problem in the attached file. Negative CF is to be adjusted first from the previous weeks and then if balance amount is there then we…
Hi I am trying to use lookup function in one of my module and I am getting the error message ' Format of mapping used for lookup doesn't match any dimension of the source' The formula I am trying to u…
I am building a Cost Forecasting Model which uses different methods for calculating the forecasted amount depending on the cost category and the number of years into the future. One of the latest use …
Hello, Situation: I have a grid where a user enters in the number of tables they would need for an upcoming event. In the grid, I have a "submit for approval" checkbox for the user to check once they …
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formu…
Hi, Have a small challenge - I'm trying to import line items from one module with 2 dimensions and into another with 4 dimensions. The 3rd dimension in the latter is set to ask on import but the 4th i…
Hi Planners, While I was working on graphs I found something weird going on while Publishing graphs using DCA. I am not sure if this is supposed to work exactly the way it is or is it a bug in the sys…
“Rule 4.01-08": Article 4, Chapter 1, and Rule 8 – “Avoid Refresh Buttons”. Educate the users to use the Refresh option in the toolbar rather than action "refresh" buttons to open dashboards Here is h…
Hi I am trying to change the pivot for my model by making the line items as columns and comp incoming inprocess demand sequence id as row. After clicking OK in the pivot form, I can see the changes ta…
Hi Whenever I create a line item in a general list or Module, the type defaults to Number and I have to change to the relevant type. As Text is the type we normally use, how to change the setup so tha…
It would be very helpful to have a filter option added that allows a user to filter on absolute value as well as to filter by defining a top and bottom range that returns amounts in between the range.…
“Rule 4.01-07": Article 4, Chapter 1, and Rule 7 – “Avoid buttons for Navigation”. Use the contents page for navigation rather than clutter the dashboards with buttons Here is how it was done in Pre P…
Hi Friends, I have a module abd SYS Mod 1. It has no list but only Line Items. I want to import, the Line Item value (ie. Jun 20) in the list. Kindly assist.
"Rule 4.01-04": Article 4, Chapter 1, and Rule 4 – “Turn off module page selectors”. Show the page selector is appropriate but try and drive the selection from a general page selector. Here is how it …
Hi, I have a list called Apple having items A,B, A+B. A+B should contain the addition of data of A and B. In the module i have a line item called data and applies to Apple list. I have to write the lo…
Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured withou…
Hi All, I am trying to build a waterfall chart and issue i am facing is on the End Total. Scenario - Publish a waterfall chart of basis points value ( not absolute numbers ) or you can consider the pe…
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two t…
Hi, I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also in…
Hello, I would like to create an easy way to add or delete some items from a general list for the end user. I saw that i can create an action button "create" to do that, but i can't find the list Do y…
I want to make sure that I optimize my if statements, hence some question * If you need to get a maximum of two line items, is it more efficient to use an if statement "if a > b then a else b" or to u…
In the old UX, when you published a Text Formatted Line item, you could make the text box as big as you want. In the NUX, when you publish a Text Formatted Line item as a field, the size of the text b…
My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the inter…
Description of the enhancement required: We would like the ability to remove filtered values individually, instead of clicking 'Reset' and refiltering the entire model list from scratch each time to w…
Hi Community, I'm looking for a solution to show the current/logged in user in a single line item that has no dimensionality. The use case for which I'm looking for a solution is a dynamic filter base…
Hello, I have finished the Level 2 - Sprint 1, and am in the preparing for Sprint 2 section. I am stuck at the section of importing from the saved views. After I downloaded the model and saved in my o…
