Forum Discussion
Custom Format String
Hi all, Is there a way to format a column that is type: decial number so that special values (like null, blank, or infinity) will return a text value of "N/A"? When trying to find one of these sp...
I found a solution! For the metrics Bloomberg.EPS and Bloomberg.Revenue that come from the data source, I created measures that look like the following:
The format was reverted back to text, but I was easily able to choose the correct currency type and decimal places necessary without interrupting an "N/A" output.
To fix the % Achievement measures I had created, I adjusted the measure as follows:
Again, the formatting was converted back to text, but I was easily able to fix this as you usually would.
Can't believe such a simple solution works for this issue. I wanted to make it more complicated than it needed to be. This post helped me get to the correct output.
Thanks again to those who helped!
Test reply