Null Org Ref Code
19 August, 2013
Hi,
I have a report that returning Null on a Org Ref Code column. The report is showing blank space. Is it possible to add a value for null org ref code value, so that I can display customized text?
I have a report that returning Null on a Org Ref Code column. The report is showing blank space. Is it possible to add a value for null org ref code value, so that I can display customized text?
Hi Mentor,
Yes, this is possible, but it requires an additional step.
The only way to do this would be to create a case statement so that the calc field changes the NULL to something, and then you build your yorg ref code off that calc field.
E.g.
Calc field
Org ref code
I hope this answers your question please let us know if we're missing anything.
Regards,
David
Yes, this is possible, but it requires an additional step.
The only way to do this would be to create a case statement so that the calc field changes the NULL to something, and then you build your yorg ref code off that calc field.
E.g.
Calc field
Org ref code
I hope this answers your question please let us know if we're missing anything.
Regards,
David
It is a possible work around, although it isn't ideal if you have many views that do the same thing