Hi, For your assistance please. I created system mapping module for custom versions (List: Actual, Budget and Reforecast). Scenario: I want to get the quantity difference of actual vs budget, in my Ta…
Hello, Is there a way I can automatically change the shown period in my module when I change the time selected? See screenshot attached. I need to show the period in each line item. Thanks, Tom
The formula for 'SYS01 Time Settings by Year'.Forecast Year? is invalid: Forecast Year? = 'SYS00 Time Settings'.Forecast Period? 'SYS00 Time Settings'.Forecast Period? is not a recognized line item or…
Hello everyone, I created a line item and formatted it as text/email so I could create a link on a dashboard to email approvers. It pulls the approver's name (code-which is email address), puts in a s…
Hi, Need help with Formula. I have the following below. Please advice. 'INV01 Inventory Ordering'.Beginning Inventory[LOOKUP:'SYS07 Distribution Center Details'.Region] Thank you
Hi, need guidance with the following formula. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS04 Product Details'.Product Family, SUM:'SYS07 Distribution Center Details'.Country] Thank…
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…