Home

Calculation of a report

Kiss1485
Occasional Visitor

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.

1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies