3.3.5.2 Inventory Ordering Module Formulas

tthornton
tthornton
in Modeling

I'm really confused as to why my figures won't populate when I toggle from blueprint view . Here are my formulas. Someone please help.

image.png
image.png

Answers

  • KirillKuznetsov
    KirillKuznetsov

    I think your formula is missing something as it does not make sense to pick just a half-year value from a line item called "Weekly Safety Stock". But I will explain at least that one:

    HALFYEARVALUE formula works in such a way that it picks value from the source line item on the half year level and brings it lower. For example, for months Jan to Jun it will take the same value from H1. So it does not make sense to set Half Year in time scale settings (what you see as a small table icon called "subsidiary view", read in anapedia about it) . Bring it back to weeks. And if you added summary as i mentioned in the other your question, then you should see the results.

  • tthornton
    tthornton
    image.png

    This makes more sense?

  • KirillKuznetsov
    KirillKuznetsov

    No, please read articles in anapedia:

    https://help.anaplan.com/halfyearvalue-d78dd47b-5f5c-4e06-9788-7b1de7446b29

  • KirillKuznetsov
    KirillKuznetsov

    I recommend you review the requirements of this task you probably missing something. I don't see how this functions are actually should help you here

Categories