CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Taking out unwanted 0's

edited Mar 7, 2013 10:08AM in CRM On Demand - Reports and Dashboards (MOSC) 3 commentsAnswered
We have using a Narative view for on of our reports.  The view referencing a number and currency column.  When either the number or currency column is blank a 0.00 appears in the report. 

In the number column, we created a statement of 'CASE WHEN CAST(number as char) = 0 THEN ' ' ELSE CAST(Number as Char) END'.  The statement works for the number column.  We need the currency column to be in a normal us dollar format ($1.00), but using the same logic above takes away the dollar format. 

Any ideas on how to make this work?

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center