April 24, 2014 at 8:04 am
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.
April 25, 2014 at 7:07 am
Could you provide some sample data and what the expected result in please and I will have a look
April 25, 2014 at 7:14 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply