calcuate gross gain and gross loss in Report Footer

B

Bruce

Hi,

I would like to calculate Gross Gain and Gross Loss totals in the Report
Footer of my Report. The best way to explain this is if I start with what I
already have on the report.

1. In the Report Detail I have the Fields [Trans_Type_Desc] (which is either
Buy or Sell value) and [Net consideration] (which is a transaction amount).

2. I have a footer grouped on a date that represents a complete transaction.
This has a Text Box that calculates profit for a single transaction as
follows;

=Sum(IIf([Trans_Type_Desc]="Sell",[Net
Consideration]))-Sum(IIf([Trans_Type_Desc]="Buy",[Net Consideration]))

3. In the report footer I have the same formula which calculates a grand
total profit for my report

=Sum(IIf([Trans_Type_Desc]="Sell",[Net
Consideration]))-Sum(IIf([Trans_Type_Desc]="Buy",[Net Consideration]))

What I need next is the Gross Gain which will be the sum of transactions in
2. that are favourable.

Finally the Gross Loss which will be the sum of transactions in 2. that are
unfavourable.

Does this make sense? Can anyone help please?

Bruce
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Design of Payroll Report (Gross Pay >=$25) 1
gross order total calc 0
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
A03 - count in report footer gives me #Error? 0
Profit/Loss Calculation in Subreport 7
Calculating overtime in report footer 2
Calculating off of Sum's in a footer of a report 1
Dealing with Pecentage Calculations in Reports 0

Top