You need to sign in to do that
Don't have an account?
Cushty
Calculate total hours from all child records
Hi all,
We have an object called Project and a child object called assignment which both share a common field called hours.
A user enters an assignment and enters hours. The project page has a field which calculates the total hours from all the individual assignments
There is a hierachy structure of master project and sub projects and what I am trying to achieve is have a field on the master project calculate all the total hours from all the sub projects.
I am guessing this is a trigger, of which I have acompletely run out of capabilities and need help.
The current calculation to show the total hours on the project page was done using the salesforce rollup summaries app and I think I need a trigger of some sort using a statement to match the project id's?
Nick
We have an object called Project and a child object called assignment which both share a common field called hours.
A user enters an assignment and enters hours. The project page has a field which calculates the total hours from all the individual assignments
There is a hierachy structure of master project and sub projects and what I am trying to achieve is have a field on the master project calculate all the total hours from all the sub projects.
I am guessing this is a trigger, of which I have acompletely run out of capabilities and need help.
The current calculation to show the total hours on the project page was done using the salesforce rollup summaries app and I think I need a trigger of some sort using a statement to match the project id's?
Nick
Its a parent child relationship on the project object.
we have a calculation on the project object which totals all the hours on each assignment, but we want to be able to calculate all these totals of each sub project to roll up to a total on the master project.