Forum Discussion
Calculation of a report
I have over a thousands records to calculate a number. I have created a report for a sum total of the field with numbers. Then I want to divide the numbers by (say) 60. I have the calculation. My situation is I can only have 20 records on each page for the report. I would like to calculated each page with my calculation not the whole report. Is this feasible? If so, what kind of query, calculation or formula would I use for this kind of action.
In effect you'd like to present a sub-total every 20 rows? How about creating a summary table and using that to present your results rather than expecting the user to page through 10s of pages (you mentioned thousands of rows). You could then link out to a detailed results table.
