A Group formula summary is a Group summary which is the result of an operation between existing group summaries.
E.G. Formatting one group summary as a percentage of another

To create a Group Formula Summary, navigate to a view in Analyser and clicking the Group Summary icon
Click the Add button to add a new group summary.

The Group Summary Designer window is displayed which contains a list of options for creating your summary. (outlined in the group summary page)

Title : Optional. You may specify a name for this Group Summary
Field : Select any numerical field
*Summary Type: Select ‘Group Formula’ as the summary type.
Display Format : The Group Formula syntax is as follows:

$$ - Alerts Nathean Analytics that this Group Summary is an operation between other summaries. 
(G1+G2) – Specifies which summaries to use (where the G1 represents a Summary with SummaryID = 1 and G2 represents a Summary with SummaryID = 2) and the operation to perform.
: Separates the summary calculation from the formatting string. 
0,  You may also Select an appropriate format for your data, available display masks are outlined in "the group summary page":https://docs.nathean.com/21/en/topic/group-summary
The available operands are:
+ (Addition) 
- (Subtraction) 
* (Multiplication) 
/ (Division) 
% (Percentage) 

Display: Must be set to Group Header


Revision: 1
Last modified: Oct 22, 2019


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment