• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

Sum column values below 5000 which values are calculated values

image of tablix showing columns
I have a column in the report that has currency values called old price, then the far right column which shows only the values under 5000. I want to sum those displayed values. Because the value is in an expression I can't just sum the entire column.
0
jpl-AbDev
Asked:
jpl-AbDev
  • 2
1 Solution
 
jpl-AbDevAuthor Commented:
the header in the far right column is showing the incorrect value. I should be 4208.34
0
 
jpl-AbDevAuthor Commented:
Just added case statement to the stored proc instead of trying to do it in the report

CASE WHEN pcad.prevprice <=5000 THEN pcad.prevprice ELSE NULL END AS 'changesUnder5k'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now