-
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…
-
INV 01 Shipping Time Week
Hi I'm stuck with this formula for last 2 hours. Pls help clarify what is wrong with this? INV01 Shipping Time Week - I'm getting "Format of mapping used for lookup doesn't match any dimension of the source" 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP: Shipping Method]
-
Tree View List Limit
Is there a particular reason why I lose the ability to view a list in tree when I exceed a certain number of list items? Does anyone know what the limit is on the number of items I can add to a list before I lose the ability to see it in tree view. Thanks, Mark
-
Find Highest value
How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?
-
LI PY Country and Product Family Sales
Hi, I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a dim error when conducting the following formula below. Please assist. Formula: 'DAT02 PY Revenue to CY'.PY Revenue to…
-
Subsidiary View List Drop down
I am creating a subview drop down list of a products view so i can easily select one of the items in the list. however, when i go into the subview to select the item, nothing appears for me to select. i have removed all applies to and switched the time scale to non applicable. i have this same line item in another module…
-
How to estimate the size of a model
Hello, I would like to find an app to estimate the size of a model I can't find it on the App Anaplan Agile THank you for your help
-
Data import
How to import data from FY21 (datahub) to FY22 (Spoke model). Any inputs would be highly appreciated.
-
if formula question
I want to make if formula.. if 値変更入力欄 have values(not blank), show 値変更入力欄's value else(値変更入力欄 doesn't have value) show 前回値's value how can i make this formula? please help me...T-T
-
Level 1 Model Building Activity 5/6. Super Stuck - Need Help
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Formula Help
Hi Everyone, I’m trying to do something really simple but failing. I’ve got a list of loans and each loan has a starting date. Interest is payable every x months from the starting date. I want to create a Boolean every x months from the starting date. How do I do this? I can put a boolean in the first repayment date but…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Please suggest the process to avoid the errors...see the screenshot attached.
-
Another row has already been processed with this key
Is there any way to suppress messages after importing into a List that are a result of the 'Another row has already been processed with this key'
-
Rgarding the anaplan workapce models
Im done with the level1, level 2 sprint1,2, and 3 including conclusion also and left with the updating the history of level2 supply chain but in my workspace ,my models are not showing the models and states no model yet.... can anyone suggest what to do now...Hereby i'm attaching the screenshot also... Thank you...
-
Using Excel function in Anaplan
Hi, My question is There is a Function in Excel and there is no similar kind for function in Anaplan, so how to in cooperate that function in Anaplan Regards Surya
-
SYS08 Region and Role
Hi - I am trying to bring in Region and Role. I added them as a line item in my module: Here are all the modules: And here are my lists: Can anyone help me with how to write a formula to bring in Region and Role?