LVL2 sprint 3 inv01 correct formulae but wrong figures

Hi all,

I spent a lot of time checking all the formulae and they seem correct, but still I got the wrong figures at last.

For example, the instruction says "The Confirmed Purchase Order Receipt value has updated to 8,194 is also in Week 3 FY20 column" whereas my result is 8,020.

I also found that only the Beginning Inventory of week 1 is the same as the given example, as time goes by, the result goes further away from the correct result.

Could someone give an idea of a solution?

Regards,

Yunshu

Accepted answers

Yunshu

After some correction, some of my figures (like 8,192) are now ±2 against the correct figures (like 8,194).

Found the reason. I didn't check Override Forecast and change it to 62. Don't think it should be there.

All comments

JaredDolich

@Yunshu I think you're very close. Check your formula:

Confirm Purchase Order Receipt = IF Confirmed PO Delivery = 0 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks)

You should be getting 8,194.

If your formula is the same, check the "Final Shipment Amount"

final ammount1.png

Yunshu

Hi @JaredDolich ,

Thanks for your reply.

I think it might be the problem of my beginning inventory line item as the example shows the 1st 4 figure are 13000, 10952, 8902 and 15048 whereas mine being 13000, 10995, 8990 and 15005.

My Beginning Inventory formula is IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

I have also checked my DAT01 and found nothing wrong.

So the reason for this deviation is really confusing.

Kind regards,

Yunshu

It might be my DEM03 issue, looking into it now. Weird as I passed Sprint 2 exam without issue...

Yunshu

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…