Math operations on two columns of another sheet using SELECT

Multiplying two lists (results of SELECT statements) do not work.

You have to have a real or VC column in the Purchase table with an expression [Price] * [Quantity] and SELECT this column over the same condition you have and then SUM the result.

1 Like