INV01 SPRINT 3 ISSUE

HI Team,

I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model

1. For Beginning inventory my formula is

IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

here in week 2 of beginning inventory, it's displaying the same beginning inventory as week 1

2. Reorder flag my formula

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

it's not changing for week 6 because beginning inventory is the same for all weeks

3. shipping weeks my formula

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

It's showing on 1 in place it should show 2 for roads

Screen Shot 2021-05-08 at 3.01.58 pm.png Screen Shot 2021-05-08 at 3.02.10 pm.png

can anyone help me where am going wrong! and is my formula right or wrong?

Accepted answers

All comments

abhi1017

Hi @harishroshan

1. For Beginning inventory

IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory.

The formula written is close but needs a little tweak in the first part :- Instead of 1st forecast year you need to use "Not 1st week of Timescale" as data has to be identified and fetched through a conditional statement based on weeks .

2. Reorder flag my formula

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

Seems Right.

3. shipping weeks

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

Shipping Time weeks is calculated based on the products and the type of Shipping method used for the respective products. The formula is close, add shipping methods to find the right shipping time.

~ABhi

harishroshan

Thank you @abhi1017 i got solutions am in next step

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…