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.
Return the left, and right sides of a variable separately
Summary
i need to return the numbers of the cost center, and then the description in the next columnContent
Example
for the left side in OBI
=Left([Open Reqs].[Req. Organization Level 5];4)
in order to just return the first 4 numbers
for returning the right before the first 5 spaces i had to create a variable
=Length([Open Reqs].[Req. Organization Level 5])
then apply the variable to return the cost center name
=Right([Open Reqs].[Req. Organization Level 5];[_m_len]-5)
Not sure how to do this in BO....any ideas? Thank you!!
0