Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

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

Hello all,

I'm having trouble figuring out with this error that I'm getting. Can anyone help me out?

My formula is this:

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

 

Thank you

Tagged:

Comments

  • ismaelmaclovio
    ismaelmaclovio Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor

    @JaredDolich 

    Thanks for your reply. I tried your equation and got this error message.

     

  • ismaelmaclovio
    ismaelmaclovio Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Contributor
    @JaredDolich
    Thank you for the help. It turns out that I was missing line item "Country Made In." I added it and then put the formula and it worked!
  • RaghavendraRao
    RaghavendraRao Member, ALL USERS Posts: 1 New Contributor

    Yes, in system module put the formula to get the parent of G3 location. I have attached the screen shot for reference. then you can able to see the numbers in safety stock exception count 

     

    PARENT(Distribution Center)

Categories