Forum Discussion

BishwaR's avatar
BishwaR
Icon for Helper V rankHelper V
5 years ago
Solved

Continuous Count

Hi I have a table like below where I have to determine the Available Quantity based on the running count of  Qty On Hand and the Order Received Qty. If the order received is greater than the Avail Q...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    BishwaR 

    maybe you can try a column 

    column=if(QTYonhand < Order reveived,0, QtyOnHand - Order received)

  • BishwaR's avatar
    BishwaR
    5 years ago

    Thanks it worked

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

BishwaR 

maybe you can try a column 

column=if(QTYonhand < Order reveived,0, QtyOnHand - Order received)

  • BishwaR's avatar
    BishwaR
    Icon for Helper V rankHelper V
    5 years ago

    Thanks it worked

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      5 years ago

      you are welcome