Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6098 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

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)

This topic is 6098 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.