Understanding Expressions
Expressions are calculations that PeopleSoft Query performs as part of a query. Use them when you must calculate a value that PeopleSoft Query does not provide by default—for example, to add the values from two fields together or to multiply a field value by a constant.
You can work with an expression as if it were a field in the query: select it for output, change its column heading, or choose it as an “order by” column.
In Query Manager, you can use expressions in two ways:
-
As comparison values in selection criteria.
-
As columns in the query output.