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). An expression can be treated as a field query. When selected for output, you can change its column heading or sort it.


In this topic, you are going to create a query that displays the anticipated aid amount awarded per student per term. The data is totaled by term, but your institution will process the aid monthly to students. You want to divide the total amount for each student and term combination by four (the number of months in the term) to view the monthly amount.


Table of Contents