Forum Discussion
Formula Help
Hello Everyone, I am trying to write a formula where it adds only the negative in QTY Gap (and replaces the positive with zero) and a formula where it adds only the positive in QTY Gap (replacing th...
Hello Greg_Deckler,
Thank you for your help.
Currently, I have shipped, open order, total qty (shipped + open order), Fcst QTY, and QTY Gap (Total QTY - Fcst QTY). I am trying to add Negative QTY (which pulls the negative numbers from QTY Gap into a new column (see below)) and Positive QTY (which pulls the positive numbers from QTY Gap into a new column (see below)) and sums each one individually like below. When I do an "IF" statement using the new visual calculation the total does not sum correctly.
Thank you,
Fools_Gold