Toad World® Forums

format function in calculated field

how do i format a calculated field as currency?

how do i format a calculated field to a fixed decimal? like 0.00

is there a document that explains the functions available in calculated fields?

I always find it much easier to format the fields to currency in the final report (using excel or whatever reporting tool I am using).

However, I also use the following format function “format(Field, ‘$#,###,###.##’)” when I absolutely need to format the field in the SQL query - although this will not force the result to have 2 numbers past the decimal point (100.333 will result in $100.33, but 100.3 will result in $100.3 not $100.30).

Message was edited by: julieashton_562

Hello All,

I believe you can force the result to have 2 numbers past the decimal point by switching the last two ‘#’ to zeros.

For example: format(Field, ‘$#,###,##0.00’)

Hi, I found this reference which describes many of the functions:
http://www.techonthenet.com/oracle/