Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

Options
ismaelmaclovio
ismaelmaclovio Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hello everyone,

 

I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this?

FORMULA:

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

 

Thank you.

Tagged:

Comments

  • ismaelmaclovio
    ismaelmaclovio Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor
    @JaredDolich
    Thank you once again. I realized that I was missing 2 line items so I added them and inserted the formula and it worked.

Categories