Modeling

Data type mismatch: format other than LIST or DATE being referenced as a relation Error
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'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Can I have some help on what is wrong? Thank you! .
I'd like to pull the value of a line item based off of the selection of another line item..
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 what is chosen in the Select Option Line item, I want to pull the respective value into another module. Category Select:…
Time Range and Line item Period Allocation
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 number, within the journey there are a series of stops for loading and then discharging stock. Pages: Time Range Rows: Journey…
Custom Version
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 ?
Cannot see line items in Pivot View but available in Blue Print
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 the Blue print view. Is there something to do with any settings or is it a bug?. I've attached images for reference. If some…
Level 1 Exam Question 4
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 Model Building Activity 4 page, but the following activity page is completely blank. I was able to see a screenshot of that…
Is Display Name Property only for for Numbered List?
Hi All, Is Display Name Property only for for Numbered List? Thanks SA
What is Difference between NMX and Old module
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
Access
Dear All, Kindly advise how to get an access to workspace (free 90 days)? Kind regards, Telman
Quick Summarise Data
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 some instances to export data to excel. I believe adding some fairly simple functionality to quickly summarise data by a…
Numbered List showing numbers alongwith Display Name
Hi All, Can you please advise why it's showing numbers along with Display Name in list? Also not showing numbers for some members.
Scenario Planning and snapshot
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 about multiple scenarios, and snapshots. Wondering if there are are literatures or videos on using scenarios and how to…
Reference Model ID in line item
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 use that along with an attribute I know is unique within that specific model. I do have a plan B if not. But just wanted to…
Creating Filter to Show Lines with Sublines vs just Lines
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! Thanks
REP02 values not displaying
I currently have a filter to show forecast months only
Model 1 Exercise 9.2.5
Hello All...I input 5% on my F19 for REV 04 , then i receive 20% for my REV 05...what am I doing wrong?
New Formula Editor - Positioning and Default Setting
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 box it opens to the left\right\top\bottom depending on your setting, or if a setting is not possible then have it default to…
NaN
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 formulas I have logic which says: If Numerator= 0 then 0 else if Denominator =0 then 0 else numerator/denominator. However,…
IF NaN Formula
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(***function***) THEN 0 ELSE ***function*** Would be great if there was an "IFNaN" function to allow for cleaner/ quicker…
Allow the Modules List to be searched with fuzzy logic, the saem as the Model Search function
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 fuzzy logic when using search in the modules tab. Could we please get this implemented here?
Bring in Data formatted data from one module to another where Target does not have Time dimension
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 dimension (does not have time dimension). List B Line items (some line items plus one called Date where i need to bring in…
Order List Action for End user
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 he consider it useful. Thank you Best regards Kristina
filter time periods in list drop down
I'm attempting to show the 'remaining' months eg everything after the current period in the time settings - is this possible ? or would I need to create a fake period list?
Use "Previous" with non-timescale dimension
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 weeks, therefore I think precluding the use of a native time dimension). I understand why it's comlaining; OpeningBalance…
Get latest date and price in Month dimension
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 in sequence, it means today i can upload for 6 Apr, tomorrow i can upload for 5 Apr. I need a module then can shows the…
UX Idea: Conditional Formatting Pre-saved Templates
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 precious building time doing repetative tasks because currently I have to prepare CF for each line item from scratch. Let's say…
Get value of immediate Parent of page selector
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 selected, the value should be of total of Sub-brand level. If Brand is selected, the value should be total of Category level…
YTD time summary excluding current month
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 summary methods. I guess one solution would be to always postpone the update current month period with a full month, but it…
New UX: Ability to sort columns/rows via Show/Hide in worksheets
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 items. With this enhancement, the end users can customize their "My Pages" better and it will eliminate the need to utilize…
Circular reference for confirmed purchase order receipt
I am getting an error in my Sprint 3 activity 3.3.5.1 Create Inventory Ordering Module.when i am writing the formula for confirmed Purchased order receipt i am getting circular reference. my formula = IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0 can anyone help me please!

Modeling

Discussion List