2 Replies Latest reply: Nov 1, 2010 1:14 PM by EduardoGonzalez RSS

    Calculations in Straight Tables

      Hi everyone,

      I have a question about how to get some calculations in Straight Tables.

      I will show mi doubt with an example:

      If I have a table like this:

      FIELD1 FIELD2 *FIELD3

      1 100 100

      2 180 90

      *TOTAL 3 280 95

       

      *FIELD3 = FIELD2 / FIELD1

      * TOTAL -> (SUM(FIELD1) , SUM(FIELD2) , AVG(FIELD3))

       

      But I´d like to have something like this

      FIELD1 FIELD2 *FIELD3

      1 100 100

      2 180 90

      *TOTAL 3 280 ( SUM(FIELD1) / SUM(FIELD2) )


      How can I get it ???

       

      Thanks a lot