-
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?
-
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…
-
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…
-
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…
-
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…
-
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!
-
Error Message with Formula
Update the formulas to reference the driver data in the EMP03 Employee Driver by Role module. Formula I am using: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 Error message after using the formula: IF…
-
Dashboard design support
How many of you Model Contributors are also the ones building dashboards for your organization? In our UX Designer hub, you will find Best Practices, How To articles, and a discussion board to help you design and optimize your dashboards for stakeholders and other audiences. Take a look and let us know what you think!
-
Active employee calculation
Hi Anaplan community, I am facing a problem and need help. I created a line item (Active?) to define whether the employee is active or not. The formula that I used is: IF PERIOD('DAT04 Employee Data'.Leave Date) < ITEM(Time) THEN FALSE ELSE IF PERIOD('DAT04 Employee Data'.Start Date) <= ITEM(Time) THEN TRUE ELSE FALSE I…
-
Bulk Copy Version only on a define time period
Hello, I would like to copy my 2023 Budget Version on my Forecast version but just on the 2023 time period. The problem is when I do a bulk copy from my buget to my forecast, it also copy the 2021 budget datas and the 2022 budget datas whereas I want to keep the datas that were in my forecast. How can I easily configure my…
-
Version selection in modules
Hi All, I notice when I set up a time range that I am able to select either no time dimension, or model calendar, or the time range created by me. However for Version dimension, only notice 2 options in drop down All or none. Would it not be good to be able to choose the specific versions to which a certain module apply?
-
Rank sequential numbering and skipping certain criteria
Hello! I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, ASCENDING, SEQUENTIAL, TRUE, LIST) which works well for numbering within the cost center but includes all members of the…
-
Extracting parts from a series of underscores like 448_2021_2_2021_3_1_56
Hello All, I am having trouble extracting certain parts from the code like 217_2021_2_2021_3_1_56, that first three digits is the phase code, then year, then month, then another year, another month, version, and location code. Month and version numbers could be one or two digits depending on the date, so not sure about the…
-
What am I doing wrong on Module 6.8.3?
I can't seem to figure out where my mistake is. Did I miss adding a list within the hierarchy or is this simply an error within the blueprint?
-
Filter data on criteria that can change month to month
I'm fairly new to Anaplan and I'm sure if I'm approaching this issue correctly so I thought I'd ask here. We have sales rep data that shows what "compensation group" they belong to for a specific month, along with what they sold and earned in that month. I'm trying to create a FYTD report on this that shows each…
-
To get Boolean true after every 2 or 3 months
Hi All, I want to make a boolean check after every two months. (Based on estimate and budget customized version ). How this can be achieved via formula? (It should not be static when the year changes automatically the boolean should move according to time range) Thanks
-
Question on Calculating the Redistribution Factor
Hi, I would like to know if the way I'm calculating the distribution factor is correct? The only problem I believe would be the denominator, because I only want the product values and not the product values total. Any advise would help. Thank you
-
Survey Invitation: Dresner Wisdom of Crowds EPM Market Study
Hello, Model Contributors! Anaplan Customer Marketing is currently on the hunt for a handful of Anaplan enthusiasts to inform the research behind the upcoming Dresner Advisory Services Wisdom of Crowds EPM market study: please consider participating in its 2022 end-user survey. By Thursday, March 31, 2022, please take…
-
Level 3 Spring 1 User story 1,6
I am struggling to understand what I need to do for this activity. I created a module with G2 Country and Segment dimension but I am not able to populate this module. Am I missing something? Attached screenshot Is this what the activity is asking for?
-
DEMO MODEL FOR TRAINING
I have not been able to download a demo model for my Anaplan training using the below ....and this option also is not showing where may I get a model which I can work on while doing my training please? Thank you.
-
Link version formula to other module
Hi Anaplan community, In my FP&A model I am using Anaplan native version for tracking actuals, forecast, budget and forecast vs actuals and budget vs actuals. The business end users want the budget vs actuals to be calculated as "Budget - Actual", whereas the end users with controlling functions rather want to see it…