Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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!