-
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…
-
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…
-
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…
-
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...
-
REP05 Local Currency P&L
Hi Can someone help me where do we find LIS REP03 P&L:Items while creating a REP05 module. I couldn't find it in lists and roll ups columns even though I have created line item subset.
-
Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
-
UNDO Action
What are the ways to implement "UNDO" action/process with a help of a custom created button on dashboard in Anaplan? This UNDO button would reset values of cells to it's original initial value.
-
Date Conversion
I need to convert the text formatted data below to the date format 03/08/2022. I have a formula to do that, but the time stamp on the right interferes with my formula. How would I remove that part of the cell? Or how would I add it to my formula: DATE(VALUE(RIGHT(As Of Date, 4)), VALUE(CODE(FINDITEM(Time Conversion, MID(As…
-
L2 Conclusion - Create Shipping Export Module -
Hi everyone, I am on L2 Conclusion chapter. I have created the formula to populate Shipping cost. Please see below formula . As long as I understand the formula is correct but the aggregation i am getting is not correct. 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] Plesase…
-
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?
-
How to cascade a year boolean into months?
I have a boolean that allows users to select if they would like to add a price adjustment by years. If a user selects that they would like a price adjustment then it should apply to all months within that year. I have another module by month where if a user selected to add the price adj boolean for the year from the…
-
Dependent dropdown
How Can I add filter by country and filter by segment in this: Accounts are dependent dropdown set up on country. Thanks -Pooja
-
Deleted model
Hi, I have 2 questions: -I accidentally deleted the model i worked on during the course for level 1. Do i need this model for the exam? -When i try to start over the course from scratch for practice purposes, the model I download from chapter 1 already contains data? Can someone help please. Thanks, Jacob
-
Implement Start and End
Hi I have a config module(Config Module1) that contains key-value pairs with start and end dates. For example customer_id (format = text) customer_name (format = list formula = finditem(list1, customer_id)) keyvaluestartend1cust1categoryc1March 01, 2022March 05, 20221cust1categoryc2March 06, 2022 2cust2categoryc1March 01,…
-
Multiple data write actions per button press
Hi all, I have a button that updates a boolean line item in order to change the status of something. Is there a way to have it so when I press the button, it sets multiple line items boolean's? Ideally I'd like it to update multiple line items from one button press. Thanks, Sam
-
Rank list items based on multiple ranking levels
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I…