Total in Free Form and spec. fuction

[speedium]

Hi all,

I have a question:

I have a view in the database, which has two columns. I need to do Free-form report form this table and at the end (TOTAL) for first column I must do SUM of this column and ‘total result’ of second column is special function.

My example is not exactly, what I need, but everything unknown may by included.
Could you advice me, how to do, what I want?

SET STYLE = OFF
SET PAGE-NUM = OFF

TABLE FILE FILENAME
HEADING
"HEADING FIRST LINE"
"HEADING SECOND LINE"
" NUMBER NUMBER"
" NAME COL1 COL2 "
" -------- ---------- ----------"
BY NAME NOPRINT SUBHEAD NOPRINT
"<30><NAME <COL1 <COL2"
FOOTING
"<38>TOTALS: ??_SUM OF COL1_?? ??_funcOf(SUM COL2)_??"
END

 

[focwizard]

In a FOOTING, you can use '<TOT.field' for the column total of that field.

What kind of function do you want for COL2? Is it on each element, or on the total? You may want to use a multi-verb request, so you can get the grand total on each line, as well as the details.