MB - L2 - S3 - 3.3.5.3 Check Your Work ( SUMMARY TOTAL - MISMATCH)

zaibhamid81
zaibhamid81
in Modeling

Hi Everyone,

 

I am having issue with matching my work after putting formulas in sprint 3. All value are matching but summary totals are not matching at SKU level and All product level. Please advise what have I done wrong and how can I fix these issues. Please see the screenshot of my model against required numbers.   

 

SKU level

zaibhamid81_1-1646659697864.png

 

All product level

zaibhamid81_2-1646659726493.png

Thanks in advance.

JH

Tagged:

Best Answer

  • TimothyThomas
    TimothyThomas
    Answer ✓

    Hi @zaibhamid81 ,

     

    I think the answer lies in your line item summary settings. For something like Inventory, you probably want to set your time setting to a Closing Balance rather than a Sum. Play around with the time summaries for the line items that aren't working and see if that fixed your issue!

    Let me know if more detailed is needed,

    Timmy

Categories