Oracle Business Intelligence (OBIEE)
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment