I have a list of records with the following fields: createdby, note type, date, duration
I'm trying to create a report that will sort by created by, list note type, date, duration and have a leading summary and grand summary of the duration field. Duration is set a number and duration_summary is a summary totaling the duration.
The report lists everything correctly except the summary are not totaling.
Leading summary - displays first duration listed and is not summarizing by duration by createdby field
Grand summary - displays .5. There are three groups, with 8 occurrences, and a total time of 9.75 so I have no clue what the .5 is reflecting.