A have a report where I need to group the data by 28 day periods.

So basically if my data started from 1/1/1900 and ended 3/29/1900

The first group would be 1/1-1/28, second 1/29-2/25, third 2/26-3/25, 4th 3/26-3/29

Also once I have it grouping correctly

Would this work correctly?

Count(Group) to give me the number of groups for instance in the above example, 4. So that if I have an average field calculated by the sum of a value in the individiual groupings and divide that by the number of groups to make the average

or would it be better off using something like

RoundUP(((DistinctCount(Date(TimeStamp))))/28)

Premise of the formula. Distinct Count of the number of days in the Time stamp field for the data range, divide that by 28 to get the number of groups. RoundUp to next whole number to account for like in the example from earlier where the last group isn't a full 28 day section. So in the above example if I used this formula without the Roundup I would come up with 3.11 instead of 4 groups like there is. So the round up function fixes that.

bump.

No one even has a that's not possible?