You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

OTBI - change field from text to number

Received Response
364
Views
4
Comments
edited Jun 9, 2020 1:53PM in Reporting and Analytics for HCM 4 comments

Summary

Changing text format fields, which include number values, to number format

Content

Hi

I have a report which shows information on Element Entries. The input value name is filtered to 'Amount' and the 'Displayed input value' field is what I would like to convert from text to number.

I used the formula Cast ("Element Entry Value"."Displayed Input Value" AS INT), however I get the error below.

Any help is much appreciated!

 

View Display Error
 
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!