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.
Using Distinct for OTBI reports
Summary
We want to see only one result for specific areasContent
Hi All,
I have one report about absences and balances which belongs departments.
We used Sum for some specific areas and got the same result for each rows and now we want to see only one of them because all of them have same results.
I tried to edit formula and use Distinct but it didn't work. (Our each columns about absences have a little bit complicated formula.) I tried to use group by but it didn't work either. Actually it seems to easy what I am trying to do however I couldn't find a proper way to do it.
1