I have a report that has time entry records. Each week is a summary level, so I can sum total time worked for each week. I'm wondering if there is any way to count the number of summary rows (the number of weeks) and display on the grant summary row. (Ultimately I want to calculate time worked per week on the grand summary so I would sum time and divide by # of weeks).

I've tried using a "power of one" type formula, but that seems to only count the records, not the weeks (below # of weeks is a formula field with value always equal to 1). In my photo below, I'd like to have the sum of the weeks appear in the grand total, "4".

In the image below, "end of week" is a formula field which calculates the last day of the work week given a specific date. Ultimately I need the number of weeks in the grand summary, so I can begin to do average per week calculations for the records, given a particular date range that could be changing. I've tried using custom summary formulas (Sum: # of Weeks) but of course that gives me the total number of records rather than the number of weeks.

enter image description here

  • can you provide the field details and custom summary formula which you have tried so far – Santanu Boral Aug 8 '17 at 18:59
  • I've added the information to the post per Santanu's request. If additional info. is needed, let me know. – cmayer10 Aug 9 '17 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.