3 Replies Latest reply: Feb 12, 2016 7:24 AM by Jose Luis Navas Perales RSS

    Set analysis ( based on another field)

    Jose Luis Navas Perales

      Hi,

       

      I´m trying , using Set Analysis, to filter the information in my table

      It´s possible to obtain the sum of the amounts, but only invoices not repeated.

      Something like this:

       

         "Sum({$<DISTINCT Invoice>}Amount)"

       

      Invoice     Amount

      1                15

      2                35

      3                25

      2                35

      4                15

      4                15

      5                40

        TOTAL   130



      Thanks