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

Column Formatting for hashtag results

edited Jul 6, 2021 10:22AM in Reporting and Analytics for HCM 1 comment

Content

Hi all,

I'm hoping the request I'm asking is relatively simple to do.

We have an OTBI report that when run within OTBI, displays date values as '00/00/0' but when its outputted to Excel, returns date values as '#########' when there isn't a result keyed in the field.

Is it possible to stop this via some conversion? I've tried using a CASE WHEN statement but because its a date field, it doesn't seem to work the way I'd expect it to work.

My Case When example:

CASE WHEN "FIELD"."NAME" = '00/00/0' THEN 'BLANK' ELSE "FIELD"."NAME" END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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