Rollup Helper Use Case Library | Passage Technology

FinancialForce - Sick time and Vacation time in Projects

Written by Passage Technology | May 13, 2014

Problem: We needed a field to show total hours tracked to Sick time and Vacation time Projects for a Resource.

This is easy to do with reports, but we needed fields to be populated so we could use them in a formula to calculate PTO balances.

Solution: Start by creating a rollup from the Timecard Header object to a field on the Contact object.

  • Create a rollup from the Timecard Header object to a field on the Contact object called "Sick Hours Tracked" and "Vacation Hours Tracked."

  • Send the sum of the Total Hours field on the Timecard for all Timecards that are for the Sick Time Project, and the Vacation Time Project, respectively.