Friday, June 17, 2011

How to change negative values into positive values in OBIEE Report?

Click on the fx of the column (assuming it is not CHAR) and enter:

(columnname)*-1

If some values are, but not all, then enter this:

CASE WHEN columnname <0 THEN (columnname)*-1 ELSE columnname END

Until Next Post.... :)

No comments:

Post a Comment