locked
Matrix: How to find the average of a Total Row RRS feed

  • Question

  • Hi, I am trying to find the average of the total row. By default it populates all the cells with a sum but i would like to change the one with ??? to get the average of the total row and not the column.

     

     

     

    Averages

    Product

    01/12/2011

    02/12/2011

     

    Sugar

    100

    20

    60

    Salt

    50

    30

    40

    Total

    150

    50

    ?????

    Thursday, December 8, 2011 9:06 AM

Answers

  • Try below expression in textbox of (????)

    =RUNNINGVALUE(Fields!Val.Value,SUM,Nothing) / CountDistinct(Fields!DateField.Value))
    Change field name as per yours.

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Sandip Shinde Thursday, December 8, 2011 9:44 AM
    • Marked as answer by Kennilove Thursday, December 8, 2011 9:48 AM
    Thursday, December 8, 2011 9:27 AM

All replies

  • Try below expression in textbox of (????)

    =RUNNINGVALUE(Fields!Val.Value,SUM,Nothing) / CountDistinct(Fields!DateField.Value))
    Change field name as per yours.

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Sandip Shinde Thursday, December 8, 2011 9:44 AM
    • Marked as answer by Kennilove Thursday, December 8, 2011 9:48 AM
    Thursday, December 8, 2011 9:27 AM
  • Asim,

    You are doing great job here but your expression will give syntax error due to extra parentheses  at the end of the expression.

    Please refere correct expression below

    =RUNNINGVALUE(Fields!Qty.Value,

    SUM,Nothing / CountDistinct(Fields!OrderDate.Value)


    Thanks, Sandip Please "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.



    Thursday, December 8, 2011 9:47 AM