Hello User: Thank you for posting in Oracle Communities. This seems to be a direct PO question. I will move it to that community.
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)
Please see the note from Frederic, this thread is going back and forth couples time for couple weeks, is this due to lack of any details?
I would appreciate if someone could take a lead and resolve would be highly appreciated.