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,

RECOMPUTE

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

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

Found it.