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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to convert data type of attributes for further manipulation in OTBI

edited May 25, 2016 11:22PM in Reporting and Analytics for HCM 2 comments

Summary

Executing mathematical functions on a numeric value in a character field

Content

This may have been answered before but I was not able to find it.

I am trying to multiply the monthly salary with 12 to get to the annualized salary. Don't ask my why I am not using the predefined Annualized Salary attribute. My question is how to do any mathematical function on a numeric value sitting in the character field. Can someone correct my syntax or give me some directions?

Thanks.

cast("Element Entry Value"."Displayed Input Value" as decimal(8,2)) *12

throws the following error.

Formula syntax is invalid.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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