Focal Point
[CLOSED] EXL2K gives formulas for SubTotal but NOT Grand Total

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

December 23, 2010, 05:17 PM
kg
[CLOSED] EXL2K gives formulas for SubTotal but NOT Grand Total
I have a spreadsheet being produced by a focus program with:
ON BNK SUB-TOTAL MTH_CHG HIST_CHG MULTIUSE CODE135
ON TABLE RECOMPUTE MTH_CHG HIST_CHG MULTIUSE CODE135 AS 'Total Charges for Client'
ON TABLE PCHOLD AS BILLACCT FORMAT EXL2K FORMULA

the subtotals are getting the formula but the grand total is not. if i run the report for a smaller number of records, all totals get the formula. Is this a known issue or am i not using this correctly?

This message has been edited. Last edited by: Kerry,
December 23, 2010, 05:25 PM
Waz
Have you checked for known issues in Techsupport ?

Also please update your signature with your version and OS.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!