I have a report that has subtotal rows and then a grand total row.
the report has several columns with two being INCOME, COST, and one being PERCENTAGE.
After report is complete I would like to show the
(INCOME subtotal - COST subtotal )/INCOME subtotal in the PERCENTAGE subtotal column
Income in the report as text with dollar sign and commas
one report has 4 subtotals and one grand total row
INCOME BREAK_COMPANY_5 (the grand total is the 2nd INCOME BREAK_COMPANY_5 - the only difference in the html is the color of the row )
Full Grand Total row html
<td class="apexir_AGGREGATE_VALUE" style="white-space: nowrap; background-color: rgb(112, 163, 224);" align="right" headers="Percentage % BREAK_COMPANY_5"></td>