2 Replies Latest reply: Sep 2, 2014 9:16 PM by jagan mohan rao appala RSS

    Total of two formulas

      I would like to have one column (New field) with the total based on a calculus. However, I can not manage to do this:

       

       

      The calculus is

      sum(distinct width)
      *
      sum(large)


      and it should multiple line per line having a new column (new field) being the sum of all the lines, should it be with an aggregate, including total in set analysis?


      For example, I have the large and width and I want a new column with the sum of each line after doing the calculus width*large


       

      largewidthwidth*largeNew field
      85,370,01090,931,56
      80,160,00790,631,56



      any ideas?


      Thanks in advance.