Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 6:33 AM
Points: 930, Visits: 2,433
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: Tuesday, February 9, 2016 7:31 AM
Points: 355, Visits: 773
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