AM22 Tech
»
Technical Discussions
»
Asp.net / Web development
»
how to use sum function and check for Null column values in reportviewer
 Rank: Advanced Member
Joined: 2/16/2010(UTC)
Posts: 30
|
I am trying to sum the values in a column in reportviewer. The column may have some NULL values and hence the sum function throws #Error.
Can anybdy help?
|
|
|
|
|
|
|
|
|
|
 Rank: Administration
Joined: 1/9/2010(UTC) Posts: 449  Location: India Was thanked: 1 time(s) in 1 post(s)
|
Try to use the following formula in the text box where you want your sum to appear. I just tried it and it works:
=Sum(CDbl(Iif(IsNumeric(Fields!INV_AMT.Value), Fields!INV_AMT.Value,0)))
Note: INV_AMT should be your table's column name for which you want the sum to appear.
|
|
|
|
|
|
Rank: Guest
Joined: 12/12/2009(UTC)
Posts: 540
|
|
|
|
|
|
|
AM22 Tech
»
Technical Discussions
»
Asp.net / Web development
»
how to use sum function and check for Null column values in reportviewer
Forum Jump
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
