I have a portal in my database and I would like (if possible) to have a field that will capture the total value for certain fields. My portal is set-up similar to this:

Job Number

PO Number

Type

Invoice Number

Invoice Amount

I have 2 different types of entries - CONTRACT or AWO. I would like to have TOTAL AWO and TOTAL CONTRACT fields set-up, so that if TYPE = AWO then it gives a total of the invoice amount for only those entries, and same thing for TYPE = CONTRACT. Does anyone know how to do this?

Create calculated (or auto-entry) fields in your related table that correspond to your CONTRACT and AWO fields.

E.g.

Amt_AWO [case(type="awo";amt)]

Amt_Contract [case(type="contract";amt)]

Create the fields in the parent table like this:

Sum(related::Amt_AWO)

Sum(related::Amt_Contract)

Perfect! Thank you!!