Page Comparison

By means of integration, criteria can be defined to keep an accurate stored count or sum of a value across all items within the valid criteria.

Instructions

Go to the Integrations Shared Lookup to define the new count or sum.
Module → Module Name → Shared Lookups (tab) → Integrations
Select +New in the top left to add a new Sum or Count within the Integrations Shared Lookup.
Defined the Name, Description, and select which Module this is for.
Select 'Add a new Connector operation'.
Specify the selection as SQL, Count/Sum, and the Field to be totaled, then Save in the bottom left.
Image Added
Go to the Field List and select the field which will store the resulting value/total.
Module → Module Name → Forms (tab) → Create/Update Fields… → Field for storing result
Select Edit in the Field Value section of the Field Properties.
In the ‘Take value from’ section select Execute Integration.
In the ‘Execute an integration’ section select the Name of the Integration defined previously.
If ‘Additional Criteria’ is needed it should be defined here by selecting the required equality statements.
Image Added

Info