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

[Jabbs]

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.

[Pratyay_Rakshit]

Use a SELECT expression.

I am posting the logical blocks

SUM(SELECT(Table Name[Column concerned], [Status]=“YES”)]

[Jabbs]

Pratyay_Rakshit:

SUM(SELECT(Table Name[Column concerned], [Status]=“YES”)]

SUM(SELECT(Table Name[Column concerned], [Status]=“YES”)]

SUM(SELECT(Returns[Column concerned], [Received]=“YES”)]

Returns - name of the table
Received - Y/N value

what do you mean by “Column concerned” ?

[Pratyay_Rakshit · Accepted solution]

The column for which you want to sum the values.

[Jabbs]

ok it works. thank you so much