About Lkishko

Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a suggestion for the conditional formatting of the % Full line. Thanks for the help! ... View more

Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a suggestion for the conditional formatting of the % Full line. Thanks for the help! ... View more

Hi! I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get: IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0 I've found similar questions in the community but no clear way to resolve this. Also, instead of the "-1" in the offset formula I would normally include "0" but this isn't the issue. Can someone help me resolve this? The goal is to have the 1 from "PO Submitted" be reflected in week 3 of "Confirmed PO Delivery" Thanks in advance! ... View more

Hi! I was hoping someone could share if I am missing something in this activity: and this is what I have in my module: I am having trouble matching the rounded cells and I think it's throwing off the rest of the data. Anyone have advice on how to fix this or if I am correct because I don't understand how 59.47 rounds to 60? Thank you ahead of time! ... View more