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/