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)

      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

      any ideas?

      Thanks in advance.