4 Replies Latest reply on Feb 7, 2013 10:28 AM by Blair Gibb

    Aggregation (sum and percentage) on a column

    Davide Della Rocca

      Hi all,

      I have a table with a column 'Quantity' and i'd like to have :

      1. a field/variable TotalQuantity with the sum of  *all*  the values of this column wich can be used in additional calculation (using

      2. a calculated field wich provides the percentage of each Quantity value related to the total (TotalQuantity)

       

      Thanks in advance for any help someone can give me !

       

      Cheers,

      Davide