title: OBIEE 12.2.1.2 - Custom Data Format for numeric values
body: <p>I am facing problems with the custom data format in the latest OBI release.</p>
  
  <p>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:</p>
  
  <pre><code>+$#0,#.0,,M;-$#0,#.0,,M 
  </code></pre>
  
  <p>Resulting in (picture 1):</p>
  
  <p><img src="https://i.stack.imgur.com/wQOl2.png" alt="see picture 1"></p>
  
  <p>Removing the first '0' results in (picture 2):</p>
  
  <p><img src="https://i.stack.imgur.com/lP8mg.png" alt="see picture 2"></p>
  
  <p>Is there another -global- option (without adding an extra calculation in criteria tab) for this display? Ideas and suggestions are much appreciated!</p>