Most the questions above have been addressed via this thread, but the remaining question is how to achieve "%" using Query Manager such as in the calculation: QTY_REQUESTED) / (QTY_SHIPPED) = x %
I suggested to add an Expression and try to use the Meta-SQL %DecDiv since Meta-SQL's are allowed in Expressions.
Information about Expressions and Meta-SQL's is available here:
PeopleTools 8.5x PeopleBook: PeopleSoft Query > Defining Selection Criteria > Defining Expressions
PeopleTools 8.5x PeopleBook: PeopleCode Language Reference > Meta-SQL Elements
The customer tried using an Expression but he was not able to make it work.
PS: this thread should be moved to this Community: PeopleSoft (MOSC) > PeopleTools - PSFT (MOSC)