Using Custom Format in OBIEE Answers

The report requirement is show (+) Character if the value is positive and (-) character if the value is negative and Values to be shown as "$425 K"

To achieve this format in OBI answers, we have to manually change the custom format in column properties to show the results in desired format as shown below.

"+" #,##0;"-" #,##0
$#,##0 K

Result:

To avoid blank spaces or Null Values in Pivot table view, use below format in custom format section.


#,##0;-#,##0;0