Calculations in Straight Tables

[#1]

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

[johnw · Accepted solution]

Expression 1 = sum(FIELD1)
Expression 2 = sum(FIELD2)
Expresison 3 = sum(FIELD2)/sum(FIELD1)

Total Mode for all expressions = Expression Total

[#3]

Thanks a lot