Why does the table edit page return results but the results page error?

Dawn Cawston - CPS

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):

All Absence Days Number and Trend (1).zip

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

Amrita Gupta-Oracle

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