Summing and groups

[BRABUS]

I have a report that breaks down a persons work bookings by day and within each day it sums by booking code. This is shown in the group detail.

What I would like to do now is also show a sum of those booking code totals for each day in the group footer.

I am going to smash my head on the desk as I know its got to be simple but i am just not getting it

 

[kusumerumaal]

I hope this helps:
If the detail section has that field as Field1 then in the group footer use "=Sum([field1])

You can repeat this for other footers as well - if grouping is done for more than one item. Each footer will contain the sum for items above it.

You can use this for expressions as well, "=Sum([field1]+([field2]*[field3]))".

 

[BRABUS]

No sorry that doesnt work, that gives me a cumulative total day by day as the week goes on. I need a total for each new day/date.