3 Replies Latest reply: Dec 11, 2017 3:53 AM by Jaspreet Sran RSS

    How to get 'Sum of Rows' in Text box instead of 'Expression Total' ?

    Jaspreet Sran

      Hi all,

       

      I have a Text Box to display the value for an expression like sum(A)*B, for any number of dimensions selected by the user.

      By default it is showing 'Expression Total', which is not giving correct results because of multiplication involved.

      I need to show 'Sum of the Rows' in the same.

       

      Data example :

      DimensionAB
      D1102
      D2123
      D3134

      If D1, D2 and D3 are selected,

       

      Expression Total:   (10+12+13) * (2+3+4) = 35 * 9 = 315 (incorrect)

      Sum of Total: (10*2)+(12*3)+(13*4) = 108 (correct)

       

      Can anyone suggest a solution?

       

      Thanks in advance