How do i make sumproducts ?

• jvElecenter

  SSCarpal Tunnel

  Points: 4502

  More actions

  May 29, 2007 at 9:10 am

  #173820

  Hi

   

  In excel you have the function sumproduct.

   

  How do you have this in reportserver ?

  For exemple :

  My colums are 1 to 10

  My rows are dates

  My data is number of orderlines for that day.

  e.g. :

             1           2           3

  Day 1   15        1            3

  Total column should show : 1*15 + 2*1 + 3*3 = 26

  The columns are flexible. So it can be that column 9 does not exists. If there is no data. If u can solve this issue as well I will be very thankfull

   

  Thxxxx

  
  JV

• as.lexus

  Newbie

  Points: 3

  More actions

  May 27, 2011 at 5:16 am

  #1330892

  Hi jvElecenter,

  I have exactly the same scenario. Did you found the solution? In my case dates are generated by Matrix and are dynamically growing. Excel sumproduct was used before for that kind of calculation, but now I need to migrate it to Reporting Services.

  All your ideas will be helpful for me.

  Thankx

  Alex