Focal Point
[CLOSED] Average and Sum showing in Subtotals

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7817071136

May 30, 2013, 10:09 PM
WFLurker
[CLOSED] Average and Sum showing in Subtotals
I have to this report and on the subtotal on the Amount columns each one is different:

Amt1 - Sum the columns
Amt2 - Sum the columns
Amt3 - Average the columns
Amt4 - No subtotal



What is the best approach to do this?

ON GROUPB SUBTOTAL SUMS EACH COLUMN

ON GROUPB SUBFOOT
??

Many thanks.

This message has been edited. Last edited by: <Kathryn Henning>,


WF 8105M
- Portal, Dashboard
- Rcaster, Data Migrator
- Windows 2012 Client Server
- Dev/App Studio 8105
- Data: SQL, Oracle, Neteeza,MVS
May 30, 2013, 10:42 PM
Danny-SRL
SET SUMMARYLINES=NEW
TABLE FILE CAR
SUM SALES RCOST DCOST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL SALES AVE. RCOST
END



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

May 31, 2013, 10:45 AM
WFLurker
thanks!!

Need to take a 101 WebFocus course again


WF 8105M
- Portal, Dashboard
- Rcaster, Data Migrator
- Windows 2012 Client Server
- Dev/App Studio 8105
- Data: SQL, Oracle, Neteeza,MVS
May 31, 2013, 10:54 AM
Danny-SRL
Lurker,
You are welcome!
Are you pure mainframe/focus?
Or WebFOCUS running remotely on the M/F?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

May 31, 2013, 07:50 PM
WFLurker
Mix bag of everything.

MVS to create Focus files and Dev Studio to create reports.


WF 8105M
- Portal, Dashboard
- Rcaster, Data Migrator
- Windows 2012 Client Server
- Dev/App Studio 8105
- Data: SQL, Oracle, Neteeza,MVS
June 04, 2013, 10:12 AM
WFLurker
Are we able to get Weighted Average using

ON COUNTRY SUBTOTAL ?


WF 8105M
- Portal, Dashboard
- Rcaster, Data Migrator
- Windows 2012 Client Server
- Dev/App Studio 8105
- Data: SQL, Oracle, Neteeza,MVS