Modeling

Another Question
Good Afternoon, I am yet getting another error... Data type mismatch: format other than LIST or DATE being referenced as a relation Anyone what this mean? Thanks Tony
how to hide the unique identifier when we duplicate a display name in a numbered list
For eg. I have two line items display name as Brazil here as an example. I want both of them to be displayed as Brazil only and not Brazil(#17) & Brazil(#18) in the Tree View. The issue is only in the Tree view. When we use this list in a module, the display name is shown as Brazil only. The issue stands in the Tree view…
Aggregate value of lineitem
Hi team, I need to aggregate of a line item-1 with number of accounts and display in another lineitem2 in same module. Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it) LineItem 2 Total Revenue by Country = SUM of account sales target of all the accounts coming under that…
Pro tips: Troubleshooting calculations
The Anaplan team is always looking for stories of Anaplan in action, seasonal planning tips and tricks, and use case-specific studies on how to best use the product. Recently, Stephen Rituper and I (both from our Operational Excellence Group) sat down with a few top Master Anaplanners to hear from them on their specific…
How to use “SUM” function in Anaplan: Explanation Through an Example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of SUM…
Level 1 Activity 9.2.3 Revenue decimals ?
While double checking some of my summary and formulas, I noticed that in Rev03 Margin Calculations I have decimals in my totals. However, in the verification screenshot there are no decimals. I checked the formula for Revenue and it is set to Number>with No-decimals. I checked the formula for the References in the line…
Display list items with non-zero values for sub-list creation
How would you go about creating a Module that looks in other Modules and finds every item in a list that has any non-zero values entered in a given 12 month period? The idea would be to create a table that shows, for a given group of lists, all combinations of those list items that have at least one non-zero value in the…
Accidentally Deleted Users
I accidentally deleted all the users from my workspace. Is there a way I can get to know which all users have been deleted, so that I can restore them back. I have added some users for whom I knew the mail id, but dont have the complete list.
Help with 13.11.2
Hi, I am working on 13.11.2. I have everything built out correctly except the combination chart bar graph. I keep playing with the pivot, but I cannot get the chart to go into a bar graph instead of a line graph. Can someone help?
How to find GCD of 3 numbers?
Hello Community, I have a condition, where I have to calculate the "Greatest Common Divisor(GCD/GCF)" of three numbers in Anaplan so that I can utilize that GCD value to find the ratio. In excel we have GCD function and directly we obtain the GCD value. So, is there any way we can do that in Anaplan. Thanks Puneeth HP
Convert a number to Date
Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
Need some help trouble shooting calculations?
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 working out calculations and getting them working!…
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,…

Modeling

Discussion List