Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SUMPRODUCT IN SSRS Expand / Collapse
Author
Message
Posted Thursday, April 24, 2014 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:44 AM
Points: 4, Visits: 23
Hi,

I am converting excel report into SSRS. In excel report I do have below formula

=SUMPRODUCT((Table1[DIVISION]="SSS")*(Table1[MONTH_TYPE]="MTD")*(Table1[TOTAL_DASH]))/1000

I need to convet this formula into SSRS & it should not take 0 while previewing.

Request you to please guide me.
Post #1564662
Posted Friday, April 25, 2014 7:07 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:51 AM
Points: 491, Visits: 1,466
Could you provide some sample data and what the expected result in please and I will have a look
Post #1565078
Posted Friday, April 25, 2014 7:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:00 PM
Points: 341, Visits: 751
SSRS doesn't have a built-in SUMPRODUCT function. However, you can easily make one. Just write a SumProduct function in VB (takes in two arrays, returns one number) and put it in the Report Code tab. Then you can use it in your report.
Post #1565081
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse