Another summary field question... conditional summation

[Gabe]

Hi

I am supposing I will probably have to write a script to do this, but I am just wondering, for future reference, if there is a quick way to do it.

I have a sorted list of financial transactions, some of which are marked as VOID. Is there a way to get the summary field to ignore the values of the ones which are in the VOID category?

Thanks for any suggestions.

[PeterHW]

Hi Gabe,

am I correct to assume you have want a total (or other summary), only of the records not marked as void ? So for the following records

ID Amount Status

1 100 VOID

2 200

3 400 VOID

4 500

You would want a total of 700 ? If so, make another field, calculation, result number

If (Status="VOID";0;Amount)

Then base your summary field on this field in stead and your there.

Regards,

Peter