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?