OBIEE 12.2.1.2 - Custom Data Format for numeric values

Viewed 2503

I am facing problems with the custom data format in the latest OBI release.

The following format is used and I have problems in dealing with null values - in this case significant digits, which I still want to be displayed:

+$#0,#.0,,M;-$#0,#.0,,M 

Resulting in (picture 1):

see picture 1

Removing the first '0' results in (picture 2):

see picture 2

Is there another -global- option (without adding an extra calculation in criteria tab) for this display? Ideas and suggestions are much appreciated!

1 Answers
Related