Welcome Guest! To enable all features please Register.

Notification

Icon
Error
New Topic Post Reply
how to use sum function and check for Null column values in reportviewer
Options View
Previous Topic Next Topic
03009867267499815390
#1 Posted : Tuesday, March 30, 2010 5:02:53 AM(UTC)
Quote
Rank: Advanced Member

Joined: 2/16/2010(UTC)
Posts: 30
Points: 90
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?
Back to top
Sponsor

Back to top  
Soan
#2 Posted : Thursday, April 01, 2010 4:36:55 AM(UTC)
Quote
Rank: Administration
Soan

Joined: 1/9/2010(UTC)
Posts: 393
Points: 1,158
Location: India
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.
Back to top
WWW BLOG
Guest
#3 Posted : Wednesday, January 18, 2012 1:50:25 PM(UTC)
Quote
Rank: Guest

Joined: 12/12/2009(UTC)
Posts: 443
Points: 1,361
Thanks, helped me alot.
Back to top
Quick Reply Show Quick Reply
Users browsing this topic
Guest
New Topic Post Reply
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.

Powered by YAF | YAF © 2003-2011, Yet Another Forum.NET