I have a report that uses the nl(sheets) function to create duplicate reports for each company(different sources). To make a totaling sheet I have been just using a manually entered formula for each company on a separate sheet. I have found that this makes the report take much longer to run, I assume since it has to make twice as many trips to the database, and becomes problematic when there is a change that has to be made (such as adding a company).
So I was wondering if there was a way to total (ex. (+Sheet1!A2+Sheet2!A2…)) from multiple sheets that are created when you run the report?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment You can:
put a sheet before the sheet replication and call it 'First' (hide it if you wish)
put a sheet after the sheet replication and call it 'Last' (hide it if you wish)
Then on your Summation page use the formula =SUM(First:Last!B2) or whatever cell you are summing. -
Jet Reports Historic Posts Awesome thanks! Exactly what I needed.
Please sign in to leave a comment.