Sum of column from multiplied columns

Question

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

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?

nbeason SSC Enthusiast Points: 181 More actions · Answer 2

If possible I'd like to get just the sum of this row. See attachment

You must be logged in to view attached files.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 3

Like this?

SELECT  SUM(TxQty*AvgCostOld) AS TotalTransactionCost
FROM     tblimInvTxHistory
WHERE  TxDate > '2020-08-25'
AND         TxCode = 'ADJ'

Phil Parkin SSC Guru Points: 247180 More actions · Answer 4

SSC Guru

Points: 247180

August 26, 2020 at 7:00 pm

PS, that's not a row, it's a column 🙂

nbeason SSC Enthusiast Points: 181 More actions · Answer 5

Yes! That will do nicely. Thank you very much for your time.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 6

nbeason wrote:

Yes! That will do nicely. Thank you very much for your time.

No problem, thanks for posting back.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 7

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.