AnsweredAssumed Answered

Obtaining the number of sub-summary entries

Question asked by lselsick on Jan 3, 2017
Latest reply on Jan 4, 2017 by lselsick

I will try to be succinct:
I have a report which shows the number of hours a person works each day.

The start date and the end date of the report are variable (I can enter whatever dates I wish into these fields).

I wish to work out an average of hours worked per day, but cannot figure out how to get the number of days out of the report.


For clarity: I cannot simply deduct the start date from the end date of the report as this would include non-working days such as weekends, public holidays and sick days, for example.


The sub summaries neatly exclude these days.


So, I need to get a count of the NUMBER OF SUB-SUMMARY RECORDS that the report returns, but cannot see a way to do this.


I have attached a screen shot of the layout which might help you visualise my problem (content redacted to protect the privacy of my clients). What I need from this layout is the number of days (indicated in lavender at the top of each sub-summary section – which will vary from report to report.


Any ideas?


Many thanks