Difference between revisions of "CrossLinked Calculation Fields"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (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...") |
Philip Lacey (talk | contribs) |
||
| 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]] | ||
Revision as of 01:18, 22 March 2014
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.
