What's new in Customer Journeys?

Connect and learn more! ×
OTBI - change field from text to number — Cloud Customer Connect
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

OTBI - change field from text to number

Received Response
178
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!