average of part of data set

[mart10]

I am using CR 2008

I am running a report on FX month end rates over several years. I show the data in the detail and in the ccy group show the average over the whole period - no problem

I also want to take the average over the last 3 month ends so how can I do this please

 

[pmax9999]

Use a Running Total:

Field to Summarise: FX Rate field
Type of Summary: Average
Evalute: Use a Formula (see below)
Reset: On change of Currency Group

For the Formula, use:

{Table.EoM_Date} > DateAdd("m", -3, CurrentDate)
[Code]

This assumes your {Table.EoM_Date} has a data type of "Date" (or "DateTime").  When run in June would average the rates as at the end of March, April and May.

Hope this helps.

Cheers
Pete

 

[mart10]

cheers this worked fine and has given me other ideas eg I paramatised the 3 so user can select any average period