[SOLVED] InfoAssist -Suppress Sum Subtotal of one Column
I have a report that lists currency exhange transactions. On each Trade it uses the USD exchange rate for that day to convert all the base funds to USD. The USD Exchange rate column in the subtotal is automatically added up. I'd rather it just didn't show anything at all in the subtotal line, however I can't seem to make that happen. I've tried aggregation on the field for Average or Distinct values (AVE or DST.NOONUSDCONVERSIONRATE in the Sum section) hoping that would suppress or change the sum function for that column however the subtotal line still sums the rates.
I really want the Exch Rate subtotal gone, but even an average calculation would be more meaningful.
Is there any way I can suppress the subtotal for this one column using InfoAssist? Can I modify the code through InfoAssist and have it work? Here's the section of code I think is my focus:
TABLE FILE TRADELIABILITY
SUM TRADELIABILITY.TRADELIABILITY.CREDITAMOUNT/D12.2C AS 'Deposits'
TRADELIABILITY.TRADELIABILITY.DEBITAMOUNT/D12.2C AS 'Payments'
TRADELIABILITY.TRADELIABILITY.PROPORTIONALLIABILITY/D12.2C AS 'Buy Curr,Equivalent'
TRADELIABILITY.TRADELIABILITY.__PAID_OUT/D12.2% NOPRINT
Remaining/D12.2C
AVE.TRADELIABILITY.TRADELIABILITY.NOONUSDCONVERSIONRATE/D12.6 AS 'USD X Rate'
TRADELIABILITY.TRADELIABILITY.PROPORTIONALLIABILITYUSDEQUIVALENCY/D12.2C AS 'USD Equiv,Field'
COMPUTE InUSD/D12.2=Remaining * TRADELIABILITY.TRADELIABILITY.NOONUSDCONVERSIONRATE ; AS 'USD Equiv,Calc'd'
BY TRADELIABILITY.TRADELIABILITY.BUYINGCURRENCY NOPRINT SUBHEAD
"<BUYINGCURRENCY"
BY Date SUBTOTAL
Thanks in advance!This message has been edited. Last edited by: TRue,
InfoAssist only - Version: 7703 Windows 7 Excel and PDF outputs
February 14, 2013, 09:10 AM
George Patton
It should be
ON sortfieldname SUBTOTAL
And if you specify the fieldnames you DO want, then the others you do not mention will be suppressed.
So if you have FIELD1 FIELD2 FIELD3 and you only want to see fields 1 and 3 in the subtotal it would be: