Hi, Confused with this formula. I have the following below. Please advice. 'SYS07 Distribution Center Details'.Country[SUM:'SYS04 Product Details'.Product Family] Thank you
We have a list within our Data Hub that needs to be sorted in a very specific order. We import this list into several spoke models on a recurring basis and in the past we've had to manually reorder th…
Hi, I'm having trouble writing the formula for this line item. This is what I have so far. Please advice. 'INV01 Inventory Ordering'.Safety Stock Exception Count[LOOKUP:'SYS08 SKU Details'.Country Mad…
Activity asks to create a view for export for module DAT04 Distribution Center Parameters.I cant understand the Hint.Why to use system module we can use filter in module and show only half years? Why …
I am using a composite List hierarchy: L1 List (Parents) >L2 List (Parents) >>L3 List (Children only) In a module line item, I format a line item to Type = List, and List = L3 List When I choose the p…
Can anyone help in guiding me whether my order of front-to-back model design process? 1. Document the business process 2. Determine the modules needed in the model 3. Identify the dimensions needed fo…
Hi, I have a problem where I get value summed by a wrong version returned. From a module without any versions, I want to pick up FTE values from budget version in another module which has versions and…
Activity 1.5.8 asked to save a new view Export but in my final view (file attached"export view")All weeks sales are adding up and showing under Jan19 while it should be blank as shown below What am i …
Hi Im revisiting my formulas and find that the output is the same with either A or B : Is there a difference between the two ? I want to apply the monthly growth values to weeks. A. MONTHVALUE('Volume…
Hi, Not sure which line item I need to write the formula for. Also this is the formula I came up with. Please advice. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter) Thank you
Hi Anaplanners. Just a quick update on the Ordered List Action. Great functionality - a game changer for many use cases. I will show you an example plus a way to reorder a list subset. I'm sure many o…
Hi Everyone I am using '52' to show previous year data of same month by subtracting: 'PY Month(week)' - 52 Is there a function or alternate way to use replace '52' and not use it in formula as a numbe…
Hi I am trying to use a formula to fetch the last quarter and last half year. I have a line item 'Current Quarter' in my module which has the current quarter. ex.Q3 FY20. I want to apply formula on th…
Hi, Stuck with this formula for the above Line Item. The formats are Boolean and Number so not allowing me to use a similar formula like I did for Override Shipping-write? Please advice. IF 'INV01 Inv…
Hi, I'm confused on the Line Item Formula above. Please advice. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:(Final Shipping Cost/1000)*'TRA01 Shi…
Hi, I need guidance on writing the Formula for this Line Item. My formula is below. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:Shipping Method} …
Hi, I need help on this line item formula. Below is the formula I came up with. Please advice. IF NOT+Submit Purchase Order Request THEN 0 ELSE Suggested Order Amount for the Month NOT(Override Sugges…
I'm having trouble creating the formula for this requirement: This is what i came up with: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 My model is taking …
Hi, I need further clarification. Do I create the new Line Items that are listed here and then create formulas for each based on the specific purpose? I just need clarification on what I need to do he…