Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Sum column values below 5000 which values are calculated values

Posted on 2012-09-21
Medium Priority
Last Modified: 2012-09-21
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.
Question by:jpl-AbDev
  • 2

Author Comment

ID: 38422642
the header in the far right column is showing the incorrect value. I should be 4208.34

Accepted Solution

jpl-AbDev earned 0 total points
ID: 38422762
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'

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question