INV01 Module does not match

Options
CarolinaCaetano
CarolinaCaetano Member, ALL USERS, Partner Posts: 5 New Contributor

Hi everyone, 

 

So I did all the work in the Level 2, Sprint 3, Activity 3.3.6 Test the Shipping Cost Formulas and my work does not match with the check your work.

I don't know what I could possibly done wrong and I am stuck. I'll attach a picture so you can see my work and what it should look like. 

 

Any help would be appreciated. 

Comments

  • CarolinaCaetano
    CarolinaCaetano Member, ALL USERS, Partner Posts: 5 New Contributor

    I am using the currently formula:

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

     

    Not sure what is wrong

  • CarolinaCaetano
    CarolinaCaetano Member, ALL USERS, Partner Posts: 5 New Contributor

    yes, both are checked.

  • ankit_cheeni
    ankit_cheeni Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5
    Do you see you have the same week checked in for both First Week of Timescale and NOT First week of Timescale?

    First Week of Timescale should have the formula of NOT first week of timescale and NOT first week of timescale should just be NOT First week of timescale since it’s all weeks but first.
  • CarolinaCaetano
    CarolinaCaetano Member, ALL USERS, Partner Posts: 5 New Contributor

    I got it here for this formula, thanks @ankit_cheeni