A summary question

[freecolours]

I have a few hundred records in a list view and I like to sum up all the numbers (in the money field) that have "Add" in a different textfield in the same record.

I can imagine the calculation would be something like this: If (Type) = "Add" then SUM (money)

Does this makes any sense?

[jasonwood]

I'm thinking you'd first need a new calculated money field that only shows the amount if it is of type "Add"

eg:

calcAddMoney = If(Type="Add", money, 0)

Then sum up the calcAddMoney field

[freecolours]

Thanks Jason! It works great!