Hi, I have a custom user list and a another dimension called B with 10 members. There is a input grid where user list is in pages and List B is in the list formatted line item, I want as per each user…
Hi, I have a list of products, with Country as Parent. Each product also belongs to a specific reporting group (which I've included as a line item in a Product Details module). I need to create a repo…
Hi , I have 2 lists, List 1 and list 2. I have a module with line items List 1 code, List 2 code and type and applies to as List1.. The values are as below. I have another module with applies to as li…
Hi, In the first screenshot below, the formula in Min Start Date TEST is trying to get the earliest Activity Start Date by line item Campaign New from the second screenshot. There is no empty date in …
Hi, I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible? Thanks
HI All, II need to add a state stamp into a table. My plan is to have a Line item that somehow calculated the current time (equivalent in excel would be NOW()). I then plan to use the Import data to i…
I have a case where I want to allow Anaplan to make circular references, what do I want to do? Basically to make a coffee I need: 1 Cup 1 cookie 50 grams of flour 5 grams of butter ... 150 ml of coffe…
Hi , Would like to know the learning path for Sales Performance Management. Is there a way I can simulate sales plan, quota setting, forecasting in a test environment? Thanks in advance. Murali
In module 2 sprint 3 it says keep the reorder flag referencing to Suggested order amount. WHile my formula for reorder flag is OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 I cant get it Pls cl…
Hi, I'm importing OPEX data from a datahub to a spoke model with the same dimensions but are getting 4x the values for every cell in the target module. Does anyone know why this might be? Best regards…
Hi, Module: I have created a module to submit and approve new employees. Line items of interest: Submit, Approve. Submit is boolean formatted and is TRUE when a person is submitted for approval, FALSE…
Hi, I have 2 modules say A and B Module A has id, name, key, value, key2_value For example: id name key value key2_value 1 x k1 v1 row_numidnamekeyvaluekey2_value1 1 xk1 v11 21xk2v12v1231xk3v13 42yk1 …
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] I have used the abovementioned formula for SHipping time weeks but no data is show…
Hello. Can anybody help? I struggle with the Level 1 model building exam. "in the level 1 model , update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes m…
HI I am using the above formula but getting an error. I understand I have to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item looking up SYS08 SKU Details'.Code and S…
Hi all, I've been wracking my brain on INV01 and just when i think i have it, I notice that my numbers starting in Week 3 for beginning Inventory are off by 2. See screen shot attached from my module …
Hi I'm confused by the guidance in Anapedia on Monthvalue and Yearvalue functions whilst doing the Level 2 Model building. Having been advised to use these as part of the training to result in a boole…
Hi, I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year . Module is by Year dimension . for example - I select FY 20 as dimension…
Dear Community, Could anyone please help me to implement a requirement? We are getting a monthly file from various manf. locations that tells the available inventory bucket values for various product …