Post reply

How do i make sumproducts ?

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply