Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to convert data type of attributes for further manipulation in OTBI
Summary
Executing mathematical functions on a numeric value in a character fieldContent
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.
0