PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS Query - Substraction in Group By Clause

edited Feb 11, 2015 10:08AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Hello !!!

I have following requirement. My PS Query is Having 3 columns with following values.

Col1     Col2     Col3

K1         8          2

K1         8          2

K1         8          2

Requirement was to have Sum of Col3. So I modified query using SUM(Col3) as aggregate expression. Now My Output looks like

Col1     Col2     Col3

K1         8          6

Now...I want 4th Column which will be Subtraction of Col2 - Col3 so that output looks like

Col1     Col2     Col3     Col4

K1         8          6          2

I can use VIEW and implement this but I want to know if this can be achieved using PS Query. I have also tried using expression but its not working.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center