PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

query's aggregate sum amount is off by $.01

edited Nov 26, 2025 4:42PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓

Hello, I created a query but I find that the aggregate sum of the amount is off by $.01.

See screenshots:

If you add up the five amounts above, the sum is $5364.52

The field is an expression:

But if I update the aggregate to 'Sum' and run the query again, the sum is off by $.01

How do I make the query sum match the actual sum? Thanks for your help.

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