<div>
Without seeing your table structure it is a little difficult to know, but something like this should work:<br />
<br />
Select Account, SUM(OverageRemain)<br />
From &nbsp;TableName<br />
Where SIGN(OverageRemain) &nbsp;!= 1<br />
Group By Account
</div>


Without seeing your table structure it is a little difficult to know, but something like this should work:

Select Account, SUM(OverageRemain)
From  TableName
Where SIGN(OverageRemain)  != 1
Group By Account

<div>
Have you tried my solution? It should work for you.
</div>


Have you tried my solution? It should work for you.

<div>
<div class="content wysiwyg-content">
Hi Xperts.<br />
<br />
This might be an easy answer for you guys, but its a tough question for me!<br />
<br />
I've built a simple SQL report which needs to total wirless accounts which have negative message balances on their unit's.<br />
<br />
and then sum only the negative values in order to produce a total of the negative numbers ignoring the positive numbers.<br />
<br />
EXAMPLE of what I need:<br />
<br />
Record 1 Value &nbsp;2<br />
Record 2 Value -2<br />
Record 3 Value -2<br />
<br />
SUM of ALL records = &nbsp;-4 which ignores the positive numbers<br />
<br />
My current formula doesn't work because it 'sums' everything instead of just negative numbers.<br />
<br />
=Sum(Fields!OverageRemain.<wbr />Value)<br />
<br />
Thank you very much for your help.<br />
<br />
Bill
</div>
</div>


Hi Xperts.

This might be an easy answer for you guys, but its a tough question for me!

I've built a simple SQL report which needs to total wirless accounts which have negative message balances on their unit's.

and then sum only the negative values in order to produce a total of the negative numbers ignoring the positive numbers.

EXAMPLE of what I need:

Record 1 Value  2
Record 2 Value -2
Record 3 Value -2

SUM of ALL records =  -4 which ignores the positive numbers

My current formula doesn't work because it 'sums' everything instead of just negative numbers.

=Sum(Fields!OverageRemain.Value)

Thank you very much for your help.

Bill

How do I sum only negative field values in MS SQL reports

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.