Skip to main content

Auto subtract inventory

  • December 25, 2018
  • 2 replies
  • 15 views
D

Hi,

I need to subtract the inventory from my Dec Sales table which consist of Quantity and Type.
How can i do it ? Which formula is suitable for me?
Thank you in advance.

Regards,
Darren.

    2 replies

    D
    • Darren_Kueh
    • Author
    • New Participant
    • 1 reply
    • December 28, 2018

    Any expert care to help out ?

    A
    Forum|alt.badge.img+19
    • AlliAlosa
    • Inspiring
    • 382 replies
    • December 28, 2018

    Any expert care to help out ?


    Is the column “Done” indicating which items need to be subtracted? If so, I think you will need to use a conditional roll-up. On your Dec Sales table, add a column with the following formula:

    IF(Done = 1, Quantity, 0)

    The result will be a column with only the quantities that are “Done”/“Out”. Then on your Inventory table you can use a roll-up to sum those quantities and subtract from the total.


    Terms & ConditionsAccessibility statement