Filtered Group Totals and Grand Total

[paddydog]

I have a report that lists customers' transactions over 90 days,
grouping and sub-totalling by customer to give balances over 90 days.


Some of the balances / group totals are credits, i.e., 'negative' and I
want to exclude these from my report. I have used a filter at the group
level to do this which works well. However, the report 'grand' total
held in the report footer still shows the total of all balances, not
just the 'positive' ones I want report on.


Can anyone tell me the best way to deal with this to get the correct
total.

 

[Sheco]

You could add a new "calculated field" to your DataSet. The calculation formula would be something like:[tt]
=iif(Fields!MyField.Value > 0, Fields!MyField.Value, 0)[/tt]

I can't say this is the "best" way but it should work.

 

[paddydog]

Hi Sheco, thanks for your post but that doesn't work for me.