Item Calculations

Available Item Calculations

• AverageExpression — An expression that takes values from one or more fields and returns the average of them.
• BSFExpression — Uses script code from the Apache-BeanScriptingFramework to calculate values within a single row of a report.
• BSHExpression — Uses script code to calculate values within a single row of a report.
• CapitalizeStringExpression — An expression that takes value from a given column and returns the capitalize version of it.
• ColumnDifferenceExpression — An expression that takes values from two or more fields and returns the difference of them.
• ColumnDivisionExpression — An expression that takes values from two or more fields and divides all values.
• ColumnMaximumExpression — An expression that takes values from two or more fields and returns the the greatest value of them
• ColumnMinimumExpression — An expression that takes values from two or more fields and returns the the smallest value of them
• ColumnMultiplyExpression — An expression that takes values from two or more fields and and multiplies all values
• ColumnSumExpression — An expression that takes values from two or more fields and returns the the sum of all values
• ConvertToDateExpression — Converts string to a date type
• ConvertToNumberExpression — Converts string to a numeric type.
• DateExpression — Constructs a date using the specified parameters.
• DateSpanExpression — Computes the difference between two dates.
• MapIndirectExpression — Replaces various predefined values with values read from other fields.
• MapStringExpression — Replaces various predefined values with other constant values.
• PercentageExpression — Computes the percentage for a column in relation to a base column.
• ResourceBundleLookupExpression — Returns a translated value from a resource bundle.
• ResourceMessageExpression — Formats a string using a MessageFormat string read from an ResourceBundle. This is the expression-counterpart of the resource-message field.
• SubStringExpression — Returns a partial string.
• TimeDiffAndFormatFunction — Computes the Time between two date fields
• TokenizeStringExpression — Tokenizes a string and replaces all occurences of the delimeter with the value given in replacement. An optional prefix and suffix can be appended to the string.
• ToLowerCaseStringExpression — Converts the string to all lower case letters
• ToUpperCaseStringExpression — Converts the string to all upper case letters
• VariableDateExpression — Constructs a date using the specified parameters and using values read from various fields.

To Do List