A question on the line item Reorder Flag? Do we need to end Future Ending Inventory line item to calculate Reorder Flag? I used the formula below but doesn't pull up the correct result, can anyone please suggest?
IF Ending Inventory < 0 THEN OFFSET(Shipping Time Weeks, 2, 0) ELSE 0
Understanding is ; The requirement is to flag the reorder line item as true when the ending inventory becomes negative.
W.r.t @Misbah has mentioned above "OFFSET(x,y,z) < 0", @Sangya1 There is one condition missed in your formula i.e. defining <, >,= ,etc "OPERATORS" for the boolean formatted lineitem to get the desired result.
x,y,z need to be figured out.
Try this, OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0