Sum equation in reports

[kleivakat]

I have a report where I want to calculate total rentable square footage. I
have square footage for three different kinds of space, office space, back
office space and storage space. Each floor has a useable square footage
number, and a loss factor that is used to calculate rentable space.
Therefore my rentable calculations (all in text boxes in the detail section
of the report) are:

=[OfficeSF]*[LossFactor]
=[StorageSF]*[LossFactor]
=[BackOfficeSF]*[LossFactor]

They work fine. I get rentable for all floors in the building in a list.

Now I want to total the list for each building, but since those text boxes
are calculations (and not fieldnames), I don't know how to add them together.
I tried giving each text box a name (OffRentable, StorRentable, and
BackOffRentable), and then used the calculation:

=[OffRentable]+[StorRentable]+[BackOffRentable]

When I run that report I get "Enter parameter" boxes for each of those
fields, and then nothing shows up in the report.

And finally, I want a report footer to calculate the sum of all buildings
for each type of space, which I think should be the same calculation, just
placed in a report footer section. Again, running the report gives me empty
space where these totals should be!

Any help is appreciated. Thanks.

 

[Sheila D]

I think you need to repeat the calculation for the total rather than try and
refer it to the field name. Something like
=SUM([OfficeSF]*[LossFactor]+StorageSF]*[LossFactor]+[BackOfficeSF]*[LossFactor]) in the report footer.

Sheila