Philip Lacey at 23:14, 9 November 2014

2014-11-09T23:14:32Z

Philip Lacey at 00:18, 22 March 2014

2014-03-22T00:18:22Z

Philip Lacey: Created page with "Calculations will only work on numeric data. Where text or a blank field is encountered it is converted to the numeric value 0. Fields with text will be included in the coun..."

2012-12-11T10:58:59Z

Created page with "Calculations will only work on numeric data. Where text or a blank field is encountered it is converted to the numeric value 0. Fields with text will be included in the coun..."

New page

Calculations will only work on numeric data. Where text or a blank field is encountered it is converted to the numeric value 0. Fields with text will be included in the count. Fields with no data at all will not be included in the count.

The calculations performed are always done when all data has been generated therefore the summary box will always appear at the bottom of the report to ensure maximum speed of report generation.

Format of this item is:

function#field#source;

Functions available:
* sum : the numeric sumation of all values
* count : a count of how many entries exist
* mean : the average
* min : the minimum value from all entries
* max : the maximum value from all entries

Source:
* parent
* child

To get the total amount of a number field in the child database would look like:
sum#strCDA_2_field_0_0#child;

Numerous calculations can be created by separting the entries with ;
sum#strCDA_2_field_0_0#child;mean#strCDA_2_field_0_3#child;

If you have any challenges using this feature please let us know.

← Older revision		Revision as of 23:14, 9 November 2014
Line 31:		Line 31:


−	[[Category:~~Scenarios~~:~~CrossLinked Campaigns~~]]	+	[[Category:Module Specific:Data Profiling]]
		+	[[Category:Module Specific:Form Management]]
		+	[[Category:Topic:Reporting]]

← Older revision		Revision as of 00:18, 22 March 2014
Line 29:		Line 29:

	If you have any challenges using this feature please let us know.		If you have any challenges using this feature please let us know.
		+
		+
		+	[[Category:Scenarios:CrossLinked Campaigns]]

CrossLinked Calculation Fields - Revision history

Philip Lacey at 23:14, 9 November 2014

Philip Lacey at 00:18, 22 March 2014

Philip Lacey: Created page with "Calculations will only work on numeric data. Where text or a blank field is encountered it is converted to the numeric value 0. Fields with text will be included in the coun..."