Trace:

Differences

This shows you the differences between two versions of the page.

--- best practices - document style reports [2016/09/14 18:19]
+++ best practices - document style reports [2016/09/14 18:19] (current)
@@ Line 1: / Line 1: @@
+** How do I get a total to show in document style report? **
+Create a field to hold this value.
+Use an action to calculate the value and save it to that field.
+For example, let's say you want a total of all the contracts sold this month.
+On the table where your contracts are create a field called "Monthly Total".
+When your contract gets marked as sold, have an action that will run a query for all sold contracts marked sold during and including this month. In the expression builder, use the SUM function to get a total of the sold price for all the related contracts.
+In your report, you can reference this field. You can't do this calculation directly in the report because the report would repeat for each record found during the query.

best practices - document style reports.txt · Last modified: 2016/09/14 18:19 (external edit)