I would like to use the column totals in an ACROSS report to compute a new value, and then to display this value beneath the Column Total at the end of the report.
Try a multiverb request. Need I say more?
But, I need the individual across values, e.g. C1, C2, etc not just the overall total.
Next year you should visit the summit
There is a wonderfull presentation that shows you all smart solution in one hour.
Worth all the time, but register in time, places are all used.
define file ...
tvalue/... = value ;
table file ...
write tvalue noprint
should give you n col total variables and n col detail variables which you can reference in COMPUTE or RECAP.
What type of compute is on your mind? Is it a function of the number of columns only or also of the values of the ACROSS sort field?
I sum SALES BY COUNTRY ACROSS SEATS.
The new value is the sum of the column-total for all seats with an even number.
-* File gcohen01.fex SET HOLDLIST=PRINTONLY TABLE FILE CAR SUM SALES BY SEATS ON TABLE SAVE END -RUN -SET &S=&LINES; -SET &T=0; -SET &SP='<+0> '; -REPEAT #COMP FOR &I FROM 1 TO &S; -READ SAVE &SEAT.A3. &SALES.A6. -TYPE &SEAT &SALES -SET &T = &T + IMOD(&SEAT + 1, 2, 'I2') * &SALES; -SET &SP=&SP | '<+0> '; -#COMP -RUN -SET &SP=&SP | '<FST.T' DEFINE FILE CAR T/I6=&T; END TABLE FILE CAR SUM SALES ACROSS SEATS BY LOWEST COUNTRY ON TABLE SET PAGE-NUM NOLEAD ON TABLE ROW-TOTAL AS 'TOTAL' ON TABLE COLUMN-TOTAL AS 'TOTAL' ON TABLE SUBFOOT "&SP" ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ TYPE=ACROSSVALUE, ACROSS=1, BACKCOLOR='WHITE', $ TYPE=ACROSSVALUE, COLUMN=ROWTOTAL(1), BACKCOLOR='WHITE', $ TYPE=TABFOOTING, HEADALIGN=BODY, $ ENDSTYLE ENDThis message has been edited. Last edited by: Danny-SRL,
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
Thanks for everyone's input.
GCohen, we have a McGyver Dynamic Subtotals/SubFoots technique under the tips and techniques section, which may be of help: http://www.informationbuilders...opers/McGyverDynamic
Happy holidays to everyone!!
Focal Point Moderator
Information Builders, Inc.
|Powered by Social Strata|