Sum of column from multiplied columns
-
I would like to get the sum of "Transaction Cost" as created from the multiplication of TxQty and AvgCostOld.
Any help would be appreciated.
SELECT Item, TxQty, AvgCostOld, TxQty*AvgCostOld AS TransactionCost, TxNumber, TxDate
FROM tblimInvTxHistory
WHERE TxDate > '2020-08-25'
AND TxCode = 'ADJ'
-
If you are going to SUM over a collection of rows, you need to define the grouping to SUM over.
All rows? By item? By date?
-
If possible I'd like to get just the sum of this row. See attachment
-
Like this?
SELECT SUM(TxQty*AvgCostOld) AS TotalTransactionCost
FROM tblimInvTxHistory
WHERE TxDate > '2020-08-25'
AND TxCode = 'ADJ' -
PS, that's not a row, it's a column
-
Yes! That will do nicely. Thank you very much for your time.
- nbeason wrote:
Yes! That will do nicely. Thank you very much for your time.
No problem, thanks for posting back.
- wrote:
Select Math from the Formula Type drop down list;
In the Choose a formula listbox, select SUMPRODUCT with criteria option;
No such option is available from within SSMS, as far as I know.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply