Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Compute in Total
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Compute in Total
 Login/Join
 
Master
posted
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
 
Posts: 580 | Registered: June 28, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
RECOMPUTE

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


WebFOCUS 8206, Unix, Windows
 
Posts: 1852 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 580 | Registered: June 28, 2013Reply With QuoteReport This Post
Master
posted Hide Post
Found it.


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 580 | Registered: June 28, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Compute in Total

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.