Summaries in Reports

Christopher Spice

Hi,

This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible.

I am making a simple equipment inventory with servicing data within it. The services are carried out on a 1,2 or 3 year rolling cycle, so I want to be able to print off a report at the start of each year to show me all of the services that are due to be carried out.

I would like to include a very simple summary of that data in the report such as the total number of services due, and the total cost associated. But there doesn't seem to be a straightforward way of doing it.

Any help would be greatly appreciated

Chris

Paul Newcome

You would want to create a new sheet (or find some space on the current data sheet) and use formulas to pull those metrics.

From the sound of things, those formulas would most likely end up being relatively straight forward.

But you cannot reference reports in formulas to pull metrics.