Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Syntax help for a BI Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Syntax help for a BI Report

Accepted answer
24
Views
5
Comments
edited Sep 29, 2020 8:43PM in Reporting and Analytics for ERP 5 comments

Summary

Need field to display 'All' when nothing is selected, but also need to format this field as a date.

Content

Hello all.  I'm looking for a bit of help with my syntax for a BI Publisher Report

I want to display the word "All" when nothing is selected, but I still need the field/object to be formatted correctly as a date on the output. I found a formula that does this, but I'm not having any luck developing the hybrid formula to do both.  So, how do I extend the All display rule to the date format formula I created? The field is called P_IN_DEL_DATE_FROM.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!