☰
Current Page
Main Menu
Home
Home
Editing My-subtotals-dont-add-up-correctly
Edit
Preview
H1
H2
H3
default
Set your preferred keybinding
default
vim
emacs
markdown
Set this page's format to
AsciiDoc
Creole
Markdown
MediaWiki
Org-mode
Plain Text
RDoc
Textile
Rendering unavailable for
BibTeX
Pod
reStructuredText
Help 1
Help 1
Help 1
Help 2
Help 3
Help 4
Help 5
Help 6
Help 7
Help 8
Autosaved text is available. Click the button to restore it.
Restore Text
#My subtotals don't add up correctly ##Question I have subtotals on my report and they don't add up to reflect the correct number. Why is this? ##Answers There are a number of possible reasons why this could be the case. ###Preview Results vs. Total Results The Preview Results dropdown indicates how many records should be shown in the preview. This is just a sample of all the data in the report. If a report has 10,000 records, we don't always want to display all of those records in one page in the browser. The default number of Preview records to display is 100. Even if there are more than 100 records, by default the first 100 will be displayed. However, the aggregated subtotal will sum up all records, whether they are displayed or not in the viewer. ### TOP records without ordering If TOP (limit to N records) is used (and it is used in most cases), then subtotals results can be wrong if there is no ORDER BY (sorting) applied to at least one field.
Uploading file...
Header
 **This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at [[https://www.izenda.com/docs/|https://www.izenda.com/docs/]]**
Sidebar
 --- * [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]] * [[Release Notes]] * [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]] * [[FAQ]] * [[Tutorials]] * [[The Izenda API|/API/AdHocConfig]] * [[The AdHocSettings class|/API/AdHocSettings]] * [Developer Links and Guides](/Guides/Developer-Links-and-Guides) * [[Known Issues]] --- * <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a> * [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A) * <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a> * <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a> * <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a> --- * [Guide To Report Design](/Guides/ReportDesign) * [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs) --- * [[Acknowledgements]]
Edit message:
Cancel