<< Click to Display Table of Contents >>
Expression
The Expression whose calculated value is to be shown on an expression label.
An expression can include arithmetic operations, aggregation functions and combination of field values.
Usage of the Dataset field is as below.
Type |
Usage |
Example |
value |
datasetname.fieldname |
customer.total_children |
summation |
datasetname.fieldname.sum |
customer.total_children.sum |
average |
datasetname.fieldname.avg |
customer.total_children.avg |
maximum |
datasetname.fieldname.max |
customer.total_children.max |
minimum |
datasetname.fieldname.min |
customer.total_children.min |
ODI parameter value |
OZParam.parameterfieldname |
OZParam.CustomerName |
Form parameter value |
OZFormParam. parameterfieldname |
OZFormParam.ReportTitle |
Value of Expression ODI Name property applies to Dataset ODI Name.