Report Format

[allan.mcarthur]

I have made a report on whether documents are issue early, on time or late and the percentages of each. They are grouped in batches of seven days. ie -7 - 0, 0 - +7 etc. However the reciords which are 0 days late ie on time are being groped in the 0 - +7 rather than the -7 - 0 so I am getting a false %age. Any ideas.

 

[MadCat]

Hiya

Could you not just set the group 0 - +7 as 1 - +7 and so on, then if a report is handed in ontime it can only get grouped in the -7 - 0 group.

 

[allan.mcarthur]

Hi Madcat
The grouping is done within the properties of the field
=Int(([Days Late for 1st Issue])/7)*7 & " - " & Int((([Days Late for 1st Issue])/7)+1)*7
I have tried playing around with this but without success.