Focal Point
[CLOSED] Compute in Total

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

January 27, 2020, 12:29 PM
RobertF
[CLOSED] Compute in Total
Now on App Studio, wf8206...wrote a report thats sorts by provider and shows Encounters Per Session.

TABLE FILE HOLD_PROVDATA_FINAL
SUM
COMPUTE EncPerSess/D12.2 = ( ( HOLD_PROVDATA_FINAL.SEG01.Sess_NbrAppts / HOLD_PROVDATA_FINAL.SEG01.Sess_HrsApptLength ) * 36 ) / 9;
COMPUTE EncPerHour/D12.2 = HOLD_PROVDATA_FINAL.SEG01.Sess_NbrAppts / HOLD_PROVDATA_FINAL.SEG01.Sess_HrsApptLength;
BY LOWEST HOLD_PROVDATA_FINAL.SEG01.RPTBANBR
BY LOWEST HOLD_PROVDATA_FINAL.SEG01.PROVIDERNAME

The computes work fine but my report total is simply adding everything in the column. How do I tell it to COMPUTE in the grand total as well...not simply add the column...this is what is currently there:
ON TABLE COLUMN-TOTAL

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8206.08
Windows, All Outputs
January 27, 2020, 12:35 PM
BabakNYC
RECOMPUTE

https://infocenter.information...urce%2FSUMMARIZE.htm


WebFOCUS 8206, Unix, Windows
January 27, 2020, 12:45 PM
RobertF
Ha! Hmmm..it is now and option under: Column Total in the GUI...I'd swear it was not there a few minutes ago. Thanks! Now I must find the SubTotals icon...


WebFOCUS 8206.08
Windows, All Outputs
January 27, 2020, 12:50 PM
RobertF
Found it.


WebFOCUS 8206.08
Windows, All Outputs