Formatting Column

User_ZZQJ0

OBIEE 12c

I have a column with the following formula:

case "Facts"."Salary Amount"

WHEN 0 THEN 'N/A'

ELSE cast("Facts"."Salary Amount" as CHAR) END

When the "Facts"."Salary Amount" does appear in the column I would like to remove the 2 decimal places. I no longer see that option in column properties > Data Format since I am casting it to CHAR to accomodate for the case 'NA'

What I am getting now > $102000.00

Desired format example > $102000

Sherry George

Using SUBSTRING ?

Sudipta Gupta

You can use ROUND(expr, integer) function like shown below

CAST(ROUND("Facts"."Salary Amount", 0) AS CHAR)

User_ZZQJ0

Thanks Sudipta. This solution worked for me.