O
Oscar
I have an occupancy field that is calculated on a monthly basis from
figures that are given on a weekly basis. Our directors are awarded
bonuses based on their center's occupancy on a monthly basis but are
only paid on a quarterly basis.
So I have a report that is sorted by week ending date and grouped by
month. So in the group footer for each month it calculates the
occupancy for that month and i created an IIF statement to use the
occupancy calculation and tell me how much of a bonus they get for that
month. This field is [MONTHOCC] and appears below every month's data
as it should.
However, the report spans 3 months (for a quarter) and I need it to add
all three [MONTHOCC] for me in the report footer to tell me the total
amount each director should get paid in bonuses for the quarter.
In the report footer I've tried creating a text box with the data
=SUM([MONTHLYOCC]) and it does not work.
Any help is greatly appreciated!
Thanks,
Oscar Brown
figures that are given on a weekly basis. Our directors are awarded
bonuses based on their center's occupancy on a monthly basis but are
only paid on a quarterly basis.
So I have a report that is sorted by week ending date and grouped by
month. So in the group footer for each month it calculates the
occupancy for that month and i created an IIF statement to use the
occupancy calculation and tell me how much of a bonus they get for that
month. This field is [MONTHOCC] and appears below every month's data
as it should.
However, the report spans 3 months (for a quarter) and I need it to add
all three [MONTHOCC] for me in the report footer to tell me the total
amount each director should get paid in bonuses for the quarter.
In the report footer I've tried creating a text box with the data
=SUM([MONTHLYOCC]) and it does not work.
Any help is greatly appreciated!
Thanks,
Oscar Brown