Special total 1

[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.

Row First column Second column
1. 34 56.78
2. 45 -1.456

TOTAL: (34+45)=79 spec.func(Sum sec. column)=12



Thanks very much.

Jozef

 

[WFGuru]

TABLE FILE FILENAME
SUM COL1 COL2
BY ROW
ON TABLE RECAP TOT2/fmt = function;
ON TABLE SUBTOTAL
"<CT.COL1> <TOT2>"
END

 

[speedium]

Hello WFGuru!

Thank you for your answer, but your example is not a free form.

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
"TOTALS: ??_SUM OF COL1_?? ??_funcOf(SUM COL2)_??"
END