Level 2 Sprint 3

Donna Marie
Donna Marie
in Modeling

for Inv03 distribution center summary, line item 'stock exceptions' to show total number by Distribution center

 

I use this formula:

Inv01 inventory ordering.safety stock exceptions count[Sum: 'sys08 Sku details'.'Distribution center]

 

is this correct?

 

 

Tagged:

Best Answers

  • prabhu
    prabhu
    Answer ✓

    Hi @Donna Marie,

     

    I won't this is right or wrong,

    but i can explain you what is the purpose of this line item.

     

    The purpose of this line item is to

                          Calculate number of safety stock exception count by Distribution Center and "Product"

     

    Capture.JPG

     

    Now carefully check your formula.

  • prabhu
    prabhu
    Answer ✓

    @Donna Marie - All The Best, You are in Right Track  🙂

     

     

Answers

  • Donna Marie
    Donna Marie

    inv01 inventory ordering'.'safety stock exceptions count'[sum: 'sys08 sku details'.'distribution center', sum: sys08 sku details.'product']

     

    is this correct  now

  • Younes
    Younes

    I think your formula is correct. The system does the agregation to sum the stock exception count on SKU and get them on product because of the hierarchy. I think your first formula is correct.

    Younes

Categories