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.
Help with Percentage Formula in OBIEE Reporting
Summary
Need tile to always display a valueContent
Hello,
I need to ensure there is always a value display in the tile although the value is either below 0.00% or no value so the tile doesn't appears as not being calculated and/or empty. Please see image below for example.
Here is my current formula:
cast(count (distinct case when "Submission CSW Status - Historical"."Historical Step Name" IN ('Offer', 'Offer Status') AND "Submission CSW Status - Historical"."Historical Status Name" IN ('Offer Declined', 'Candidate Declined') then "Submission General Info"."Submission Identifier" end )/ count (distinct case when "Submission CSW Status - Historical"."Historical Step Name" IN ('Offer Status','Offer') then "Submission General Info"."Submission Identifier" end ) as double) * 100
2