I created an OLAP report and when the report initially runs, my percents in the subtotal and total lines are correct (not added together, but calculated properly).

After using the OLAP Control Panel, and selecting some options (a column sort for example), I rerun the report and all the percents are now being added in the column subtotals and totals.

I'm not sure why this would make a difference.

I have a SUMMARIZE command in my code. Would switching to a RECAP command correct this?

Thanks,
Tim

I am having this same issue. The recompute of the subtotal columns seem to be lost if you drilldown or resort on any column other than the original By field.

Was a solution found?

I am having same issue here. Still trying to figure out.

I have submitted a case to IB techsupport:

Percentage total presents correctly at first level of report.
If you drill down or apply sort to any of the columns, the percentage total
becomes a sum.

I know I could create and call individual drill down reports (defeating the
advantage of Automated Drill Down) but that would not solve the problem occuring
when end user click on a column sort button or changes the sort order using the
OLAP functionality.

Example using CAR file:

-OLAP ON
SET AUTODRILL=ALL
DEFINE FILE CAR

END
OLAP DIMENSIONS
Dimension1: COUNTRY, CAR, MODEL;
END
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE GMP/D12.2% = ( RETAIL_COST - DEALER_COST ) / RETAIL_COST * 100;
AS 'Gross,Margin %'
BY COUNTRY

ON COUNTRY RECOMPUTE MULTILINES AS '*TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
ON TABLE SET OLAPPANE CONTROL
END

Attempts to use SUMMARIZE with OLAP turned on results in FOC3245 ERROR ON
PARSING TABLE IN OLAP

I will post what I learn from tech support response

As of 7.6.1 (and subsequently 7.6.2)
ON TABLE SUMMARIZE AS 'TOTAL'
works without error.

It has been confirmed that DevStudio has a problem that if you code ON TABLE RECOMPUTE, this is adjusted to ON TABLE NOTOTAL when switching from source to report view and back. This is not even specific to OLAP actually. This is an issue with the Report Painter that has been sent to programming for review.

ON TABLE SUBTOTAL AS WELL