The effect of a YES/NO variable on the sum of another column

Jabbs
New Member

Hello
I have return form for my inventory app.
I record every return - before receiving the goods back.
I have a column. Goods received? YES / NO
with the NO option - the condition of the item remains the same.
when I receive a return from a customer (YES value) , I would like the sum of available items to increase by the number of items returned.
How can I do that ?
right now AVAILABLE column formula looks like this:
SUM([Returns][Pieces]) + [Available] + SUM([Purchases][Pieces]) -SUM([Sell][Pieces])

I just want to add YES value RETURNS.

Solved Solved
0 4 282
  • UX
1 ACCEPTED SOLUTION

The column for which you want to sum the values.

View solution in original post

4 REPLIES 4
Top Labels in this Space