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.
Consolidating lines in a union report table
Content
I have a union report below, in one of the unions I have req data and the last column is SUM(0)
In the other union I have all columns with the statement of '' except for the ID column, which reports the same value that I have in the first union, the last column reports prospects, which works good.
If I only show the number of prospects the ID will consolidate and sum to 2 - works good.
I need to be able to add in the other variables so the lines will collapse and show me the correct count of prospects for each ID. I know the '' is throwing off the line but I don't know what to do to get it to consolidate with the first union. Thoughts?
Tagged:
0