Need some help in trouble shooting calculations? How can I get this formula to work? Where do I start? Our amazing Operational Excellence Group (OEG) team share their techniques and best practices for…
Hello, I'm trying to this formula for the bonus line item and I'm getting an error message. IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Departm…
I'd like to pull the value of a line item based off of the selection of another line item in the same module. I have a LiSS Module called Category Planning. It has values in 3 line items. Depending on…
HI All, I have a question since my mind has gone blank, I hope someone can help. In my current model, i have imported data for a series of journeys which start on a weekly basis for each transport num…
i have a custom version = actual, plan, forecast Q1, forecast Q2, forecast Q3, forecast Q4. how to use switchover on custom version ?, or if i cant use switchover, how must i do it ?
I have a wierd thing happening with this particular module, where I cannot see the Line Items in Pivot and I'm not able to change the view due to this. But I can add, remove or delete line items from …
Can someone clarify something please (I'm not looking for answers since this is the exam). But portions of exam questions or activities are blank as I'm going through this. For instance, I can see L1 …
Hi I have registered for learning L1 Module in NMX and I have seen there is other L1 Module also can anyone help with this what is the difference in that
One question I always ask myself when exporting data from Anaplan into Excel for further analysis is why am I feeling the need to do this and what improvements could Anaplan make to negate the need in…
Currently, we use version for snapshots. For example, create a new version for each submission, bulk copy and lock the version. However, due to size issues, we are looking for options and have heard a…
Hi, Is it possible to pull the current model ID into a line item as text? Essentially I am trying to create a unique key across imports from multiple models so thinking as the model ID is unique I can…
Hello All, I am working on a budgeting model, and we have budget lines and sublines, and for dashboard, I just want to show budget lines when it has only one subline. Any advice on how to do that! Tha…
For the New Formula Editor is it possible to: 1. Be able to dock it at the top and left of the screen as well as the bottom \ right 2. Set a default so that each time you expand into the new editor bo…
Hello, I believe I am running into an issue where some formulas are using the Divide logic and running into NaN when dividing by 0. Does anyone have any reccommendations when converting NaN to 0? The …
Hello, I am running into issues with the "NaN" when running financial or misc. functions. This causes issues when attempting to aggregate to a parent level. My current solution is: IF ISBLANK(TEXT(***…
The new fuzzy search method available in Model Search is excellent! I use it to rapidly jump to another module. But we still must use the modules tab to copy modules. I now find myself trying to use f…
Hello Gurus, I have this scenario. Module 1 has the following: Time dimension (Month) List A Line Items including a line item called ExpiryDate that is date formatted. Module 2 has the following dimen…
Hello, do you consider enhancing the Order List Action functionality by making it accessible for the non-admin users? It would be really great the end user to be able to apply such an order whenever h…
Hi all, I understand Previous() can't be used with a non-time dimension. I have a custom dimension with a natural concept of a previous item. (it's actually a 13 period calendar that is not based on w…
Hi, Can anyone guide me how to build and create line item formula to fulfil this requirement? We have a flat data in excel, inside has date, product and price, the data can be entered and uploaded not…
As a page builder I wolud like to be able to save templates for conditional formatting to select it later for alike line items (with same dimensions in the same module). This will save me a lot of pre…
Hi, The list hierarchy defined is Category > Brand > Sub-brand > SKU When the page selector is selected, how can we dynamically get the total value of its immediate parent ? For example, if SKU is sel…
Hello community! Is there a way or a workaround for the YTD time summary to exclude the current month? I would need to do this for multiple line items in multiple modules that have different time summ…
Currently, the end user cannot change the order of list items displayed in columns/rows in the worksheet pages. In the old UX, while selecting items to show/hide, you can change the order of the list …
