We are trying to put the condition on 'Run Result Value' from the subject area 'Payroll -Payroll Run

Question

We are trying to put the condition on 'Run Result Value' from the subject area 'Payroll -Payroll Run Results Real Time' in OTBI report.

Condition is that Run Result Value > 1000 , for achieving this condition we are trying to convert Run Result Value to number as it's storing as string in subject area. Tried to_number ,double function but it's not working.

WE have tried (CAST("Payroll Run Results"."Run Result Value" as DOUBLE)) ,it's not working

Anjali_Kumari4121 · Answer

This report has been requested for audit purpose , please suggest the better solution. It will be really helpful if working session can be arranged

Anjali_Kumari4121 · Answer

Hi User_PFO2E

Run Result Value holds alphanumeric value. There is another column 'Amount' , amount is having value if Run Result Value is returning number else Amount is blank. So to fetch the number only from the Run Result Value, we have added one more condition 'Amount is not null' , over this condition we have added condition  for Run Result Value CAST("Payroll Run Results"."Run Result Value" as DOUBLE) or INTEGER , but when we are adding this condition result is getting failed.

Thanks,

Anjali Kumari

Sai Darbha-Oracle · Answer

Hello Anjali -

Please confirm if the data is only numeric or it is a alphanumeric value. CAST ('Column' as DOUBLE) should work for the numeric data.

EX : CAST("Payroll Run Results"."Run Result Value" as DOUBLE)  or try INTEGER

Define a aggregation and check results.