Summary Processes

Net Present Value: Calculates the Net Present Value for a group. Measures the excess or shortfall of cash flows, in present value terms, once financing charges are met.

• NPV Properties: Specify the Discount Rate (per period) in %

Net Present Value with Dates: Calculates the Net Present Value for a group for a series of dates.

• XNPV Properties: Specify the Finance Rate in % and select the Date Field from the drop down list of available fields.

Internal Rate of Return: Calculates the Internal Rate of Return for a group. The Internal Rate of Return of an investment is the interest rate at which the costs of the investment lead to the benefits of the investment. This means that all gains from the investment are inherent to the time value of money and that the investment has a zero net present value at this interest rate.

Internal Rate of return with dates: Calculates the Internal Rate of Return for a group for a series of dates.

• XIRR Properties: Select the Date field from the drop down list of available fields.

Modified Internal Rate of Return: A modification of the internal rate of return and as such aims to resolve some problems with the IRR. The MIRR is a financial measure of an investment's attractiveness.

• MIRR Properties: Specify the Finance Rate in % and specify the Reinvest Rate in %

Modified Internal Rate of Return with Dates: Calculates the Modified Internal Rate of Return for a group for a series of dates.

• MXIRR Properties: Specify the Finance Rate in %, the Reinvest Rate in % and select the Date field from the drop down list of available fields.

*Finance definitions came from Wikipedia: http://en.wikipedia.org

Average: Calculates an average value for the group. The average is calculated by taking the sum of all values divided by the total number of values.

Percentile: Calculates the specified percentile value for the group. The percentile is calculated by sorting the data and returning the row value relative to the specified percentile and its position in the sorted array - the largest value is the 100th percentile, lowest value is the 0 percentile, median is the 50th percentile, the 25th percentile is the value in the middle of the median and minimum, etc.

• Specify the percentile to return.

Median: Calculates the median value for a group. The median of the group is "the number in the middle" when the values are sorted in order. If there is an even number of scores there is no number in the middle so the two numbers in the middle are averaged.

Mode: Calculates the mode value for a group. The mode of a set of numbers is the smallest number that occurs most often in a group of values. If all values are unique, the smallest number will be returned.

• The mode of a string can also be calculated. The mode of a set of string values is the smallest string that occurs most often in a group of values. If all values are unique, the smallest string will be returned. The smallest string is the first in ascending sort order.

Standard Deviation: Calculates the standard deviation for the group. Standard Deviation is a measurement variability used in statistics.

Variance: Calculates the Variance for the group. The variance is calculated by taking the Standard Deviation and multiplying it times itself, StdDev^2.

Ignore 0s: Calculates the Numeric processes described above ignoring records that have a value of zero.

Count Blank: Counts how many records in a group have a blank or empty value.

Count Non Blank: Counts how many records in a group do not have a blank or empty value.

Concatenate (Strings Only): Takes all the records in a group and concatenates the strings.

• Concatenate Properties: You can insert any character or string in the boxes listed below, or leave them blank. Supported escape characters include: \n (new line), \t (tab), \r (carriage return), \s (white space character)
• Start: The character specified will appear at the beginning of the concatenated string. It is left blank by default.
• Separator: The character specified will appear in between each value of the concatenated string. The default is a comma (,).
• End: The character specified will appear at the end of the concatenated string. It is left blank by default.

The start, separator and end elements must be specified for each field an action is being applied to.

Longest: Returns the longest string value of the group.

Shortest: Returns the shortest string value of the group.

Combine Spatial Objects: Combines the area of all the spatial objects in a group.

Create Intersection of Spatial Objects: Identifies all of the overlapping areas of a group's spatial objects and creates a polygon that consists only of that overlap. This means that if the group being summarized contains two polygons that overlap and one that does not, nothing will be returned.

 

Create Bounding Rectangle of Spatial Objects: Identifies the geographic extent of all spatial objects in a group and draws a bounding rectangle to those extents.

Create Convex Hull of Spatial Objects: The Convex Hull polygon is the smallest convex polygon that can be drawn to include a group of points. The polygon will not contain any concave angles, so it will never turn in on itself.

Create Centroid of Spatial Objects: Identifies the geographic center of a group of spatial objects

Combine Profiles: Combines all the Profiles in a group into a single Profile per group specified.

Combine Horizontal: Combines all the Report Snippets in a group into a single snippet for the group laid out horizontally.

Combine Vertical: Combines all the Report Snippets in a group into a single snippet for the group laid out vertically.