Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Why does the table edit page return results but the results page error?
Summary:
I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, it shows correctly however when I click DONE it goes to the Results tab and errors. Why and how do I sort it please?
Content (required):
Version (include the version you are using, if applicable):
21D soon to move to 22A
Code Snippet (add any code snippets that support your topic, if applicable):
CASE WHEN ("Absence Calendar"."Absence Days"/100) > '25.00' THEN 'SHOW' ELSE 'GROUP' END
Answers
-
Could you change the case when as below. The report renders at my end, without any errors. However, does not return data(we do not have workforce enabled). The quotation around 25, is not needed, since the comparison is carried out with a numeric column.
CASE WHEN ("Absence Calendar"."Absence Days"/100) > 25 THEN 'SHOW' ELSE 'GROUP' END
0
