PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS Query - convert negative values to zero

edited Jan 13, 2020 9:55AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓

Hello! I'm hoping this is a relatively simple question for your Query experts. I am trying to set up an Excel to CI for our Total Rewards Statements that include leave balances and the value of those balances. Some employees' balances go into the negative, which we don't want to show. If an employee has a negative balance, we want to show that they have a zero balance instead. Is this possible in Query rather than manipulating the Excel data once we send it there?

Thanks very much!

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