0 Replies Latest reply: Nov 9, 2011 10:13 AM by samwarner RSS

    Total Mode (SUM)

      Guys

       

      I currently have a straight table will a few expressions calculating the required fields. One of these expressions is returning me the right value on each record but the wrong value in total.

       

      I have changed the "Total mode" on the straight table to Sum the total value is right now.

       

      But the issue now is that I need the total from the above in the neted expression to work out %.

       

      I think the function required is aggr but not 100 sure how to get this working.

       

      Example below.

       

      (

          (

          (sum(A)/sum(TOTAL <CUST>  A))*sum(TOTAL <CUST_NAME>  B)

          )

      *

          (if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

          )

      )

      -

      (

          (if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

          )

      *

      sum(B)

      )

       

       

       

      values in the records are

       

       

      0.1

      0.4

      0.5

      0.6

      0.7

       

       

       

      total of 2.3

       

      If i put the expression on a text box the answer is zero.

       

      thanks

       

       

      S