Total of by two fields calculation

[thefugeman]

Sorry if this is a basic question. i just can't see it!

I have a field "SoldTotal" that I want to get the sum of a bunch of records, field "ListPrice", in Tralling Grand Summary, but I only want it to total up the records who's field Sold has a "Yes" next to it.

Is a calculation in my "SoldTotal" field the right way to do this?

I have tried everything, but I just can't figure out the sytax.

any help is greatly appreciated, I hope this makes sense

Thanks Dave

[LiveOak]

If your current fields are:

Total (number)

SoldTotal (summary, Total of Total)

Sold (text)

you need to two more fields:

CondTotal (calculation, number) = If (Sold = "Yes", Total, "")

RealTotal (summary, Total of CondTotal)

When making a total conditional, the conditioning must be done with a calculation field at the record level, not with the Summary field.

-bd