CODEWITHSUNDEEP
sql-servercalculated-columnsssrs-grouping
user3643304
user3643304

Reputation: 1

Creating totals result from a calculated column. SQL Server 2016

I am trying to create 1 total for my "calcColumn". I am calculating new values based off of column 4 and resultLimit column. I cannot seem to get any grouping or rollups to work, I did not include them because it was a mess and likely VERY wrong. Any help would be GREAT! Thanks much!

SELECT
  col1
 ,col2
 ,col3
 ,col4
 ,resultNum
 ,resultLimit
 ,CASE
    WHEN col4 = 'N' THEN (.5 * CONVERT(FLOAT, resultLimit))
    ELSE (R.resultNum)
  END AS calcColumn
FROM
  table1
JOINS
  ...
JOINS
  ...
WHERE
  Col1 = 'BlahBlah'
ORDER BY
  col2 ASC;

Upvotes: -1

Views: 42

Answers (1)

user3643304
user3643304

Reputation: 1

Wrapping a select around it worked a charm. Sorry for being so general....

Upvotes: 0

Related Questions