Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Expression 1 = sum(FIELD1)
Expression 2 = sum(FIELD2)
Expresison 3 = sum(FIELD2)/sum(FIELD1)
Total Mode for all expressions = Expression Total
Expression 1 = sum(FIELD1)
Expression 2 = sum(FIELD2)
Expresison 3 = sum(FIELD2)/sum(FIELD1)
Total Mode for all expressions = Expression Total
Thanks a lot