aggregate functions vs. non-numeric data

Hot Topic

How do i watch variable values during debugging ?
Creating a double entry book keeping system
Very new to SQL Express
Using Message Queues in stored procedures
@variable in SELECT ... WHERE ... IN clause
Rows to repeat at top
Converting a parent-child table into a genrational table / text file
Connecting two cubes
Improving Debugging Performance
Why is taking so long to open/render the reports for the first time?

SQL Server

How to add a Windows User Login to a database using T-SQL
Report Designer Sorting in Details Group?
OLE DB error - TCP Provider: No connection could be made because the target machine actively refused it.
Changing user used to execute scheduled jobs
Hows does SSIS improve concurrency without loacking
sp_changedbowner bug?
job failing
SQL Server Logs under Management Menu
sp name in trigger
Problem converting VS2003 code to VS2005

aggregate functions vs. non-numeric data

RS doesn't like this expression that's supposed to total up all the debit values in my ledger:

=RunningValue( iif(Fields!Amount.Value < 1, 0, Fields!Amount.Value), Sum, Nothing)

I'm getting this error :

The value expression for the textbox ‘APTotal’ uses a numeric aggregate function on data that is not numeric.  Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data.

I take issue with its saying my data is not numeric. The matching field in the database is of type money.

Any thoughts on what i'm doing wrong

------------------
Ian Pert
CMS Software, Business Integenct Unit


Answer this question

aggregate functions vs. non-numeric data

  • inDistress

    Oh, got it. Problem wasn't my Fields!Amount.Value, but simply that 0 wasn't the same datatype. Replaced 0 with Nothing, like so

    =RunningValue( iif(Fields!Amount.Value < 1, Nothing, Fields!Amount.Value), Sum, Nothing)

    And it worked like a charm.

  • aggregate functions vs. non-numeric data
Answer this question