nelsonkh Posted May 9, 2008 Posted May 9, 2008 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?
Fitch Posted May 9, 2008 Posted May 9, 2008 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)
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now