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
|
Similar Threads
