Summing in Query with Expression

[Juliet]

Hi

I have a table with multiple Yes/No options. Same table also has a column for quantity. The unique id is style code.

New query - with quantity and an expression to multiple the SUM of YES/NO * quantity.

Yes is a negative number, ie -1. Making my sum a negative number.

Any way I can turn my Yes into a positive number?
When this number is positive - it will feed into a new query with unitpricing for a second expression.

THanks

 

[Juliet]

Don't worry - sorted.