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.

Example:
Trade 356805 - Incoming Funds $2500.00 AUD - USD X Rate 1.0455 - USD Equivalent $2613.75
Trade 356805 - Outgoing Funds $1000.00 USD - USD X Rate 1.0000 - USD Equivalent $1000.00-
Subtotal per date.......................................2.0455..................$1613.75

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,

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:

ON sortfieldname SUBTOTAL FIELD1 FIELD3

Yahoo! It works and I learned a very useful mod for InfoAssist.
Thanks George!