Calculating totals in a report (1 Viewer)

[mark curtis]

Hi,

I have a report which returns financial information spanning by month and year. The report is grouped by projectid and then year. The status of the data can be both budget or actual for a month. What I am struggling to do is calculate for example the total "actuals" for a year. I have tried to calculate it in the Year footer but no joy. I need something like
=sum([data]where the data is equal to "actual" and associated year)

Any help will be much appreciated.

 

[Chris RR]

Try something like this

ActTotal: Sum(IIf(([MYTABLE]![SW_TYPE]="ACTUAL") AND ([MYTABLE]![YEAR]=dtWhatever)),
[MYTABLE]![Act_Quantity],0))