Sprint 3 Beginning Inventory Formula not working, getting an error

Roxanid
Roxanid
in Modeling

HELP! I'm currently doing Sprint 3 and I'm getting error with my Beginning Inventory formula.

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

I'm getting the error below. What can I do to fix this? Is my formula incorrect?

image.png

Answers

  • Venki9902
    Venki9902

    Hi @Roxanid ,

    The formula seems to be correct.

    Did you check the not first week of timescale? Line items formula and its format type?

    If this not helps, can you share the blueprint view if possible?


    regards,

    Venkatesh

Categories