CONSTANT
Description
To aggregate all values from a source column to a single value, the CONSTANT
function can be used as a target table inside a PU-function. The resulting value is a constant.
Syntax
CONSTANT()
Examples
[1] Calculate the average of the case table values using | |||||||||||||||||||||||||||
| |||||||||||||||||||||||||||
|
[2] Calculate the average of the case table values using | |||||||||||||||||||||||||||
| |||||||||||||||||||||||||||
|
[3] In this example, only company codes with an average value larger than the overall average value are returned. The overall average value is calculated using | |||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||
|