PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Crystal Report to BI conversion - Query Expression

Tools release 8.54

Application Release Financials/SCM 9.2

Good day,


We are currently in the process of upgrade to PeopleTools 8.56 and eventually to 8.59 and as such, we have to convert the Crystal Reports to BI publisher.

In one of the Crystal reports, They have an expression as below and named it @Worked

Worked is an expression

if {AG_OTIME_LV_PAID.EXP10_8} = 'BOOKED' then

  {AG_OTIME_LV_PAID.TIME_QUANTITY}

else

  0;

Paid is also an expression named @Paid


if {AG_OTIME_LV_PAID.EXP10_8} = 'PAID' then

  {AG_OTIME_LV_PAID.TIME_QUANTITY}

else

  0


How do I implement this calculation in PeopleSoft Query manager?

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