About RickyTillson

So I'm having some issues (or more likely a misunderstanding) with my formula for Confirmed PO Delivery.   I'm still at the OFFSET stage & haven't yet got to the POST conversion that I think comes later based on other forum posts.   I'm trying to use: Confirmed PO Delivery = IF OFFSET(PO Submitted, -Final Shipping Time Weeks, 0) = 0 THEN 0 ELSE 1   In my head this works by saying if x weeks ago I submitted a PO then I should receive it now. This worked fine when just using the default shipping times because they were always the same.   Now that I am trying to use the Override if I submit a PO in Week 1 and change it to Air (1 week shipping) my formula for checking receipt in Week 2 is OFFSETTING based on the 2 weeks default for Road shipping from Week 2   Here is what I'm getting for Confirmed PO Delivery (0, 0, 1, 1) which I know how it is derived, but I don't know how to get this to be (0, 1, 0, 1) using the 1 week shipping in week 1, and 2 week shipping in Week 2 - it's almost like I need the OFFSET to be recursive       ... View more

Hi,   I've created my Global Demands Assumption dashboard and think I've followed every step but I am coming up with a couple of issues.   Firstly I have a different growth rate for Chocolate for February 2020. When checking the "View the Global Demand Assumptions Dashboard" (https://learning.anaplan.com/mod/page/view.php?id=12077) it shows a growth rate table that looks like this:   however mine looks like this:     When going back and checking my DEM03, DEM01 and raw data in the csv I appear to always have 3% growth for chocolate in February. It is even shown as 3% in the "Activity: Verify DEM03 Formulas & Summary Methods DEM03 Line Item Formulas" (https://learning.anaplan.com/mod/page/view.php?id=12070     I just wanted to check if I've missed something - I did have an issue where I'd forgotten to remove an override that was causing some of my numbers to be be out by 2. I've gone through every step and re-read the instructions but can't see anywhere where it should have been adjusted and changed to 5%       The second weird thing I have is on my dashboard when I first open it neither of my tables seem to sync the time properly. My growth% table shows Jan-Jun and my Forecast table only shows Jan20.   If I change the FY dropdown to FY21 and back to FY20 it shows all 12 months in both tables. I've tried removing and adding all the elements again but it seems to do the same thing each time.   ... View more

Hi,   I've created my Global Demands Assumption dashboard and think I've followed every step but I am coming up with a couple of issues.   Firstly I have a different growth rate for Chocolate for February 2020. When checking the "View the Global Demand Assumptions Dashboard" (https://learning.anaplan.com/mod/page/view.php?id=12077) it shows a growth rate table that looks like this:   however mine looks like this:   When going back and checking my DEM03, DEM01 and raw data in the csv I appear to always have 3% growth for chocolate in February. It is even shown as 3% in the "Activity: Verify DEM03 Formulas & Summary Methods DEM03 Line Item Formulas" (https://learning.anaplan.com/mod/page/view.php?id=12070 😞   I just wanted to check if I've missed something - I did have an issue where I'd forgotten to remove an override that was causing some of my numbers to be be out by 2. I've gone through every step and re-read the instructions but can't see anywhere where it should have been adjusted and changed to 5%     The second weird thing I have is on my dashboard when I first open it neither of my tables seem to sync the time properly. My growth% table shows Jan-Jun and my Forecast table only shows Jan20. If I change the FY dropdown to FY21 and back to FY20 it shows all 12 months in both tables. I've tried removing and adding all the elements again but it seems to do the same thing each time. ... View more