DollarFormat rounding problem?

Question

DollarFormat(1214.225) is returning $1,214.22.  I would expect $1,214.23.  I think I would have noticed this before and I am wondering if it a CF2016 issue or is this the normal behavior.Thanks!

Grae Desmond · Accepted Answer

I was being lazy and just copied and pasted the original example. Should've played more. Strange it would work by adding another decimal place. Definitely a bug. Are you going to submit it? If not i can add.

Tracker

James Moberg · Answer

If you want better rounding with finer grain mods for up, down and even rounding, consider using the decimalRound UDF. After rounding, prepend the cosmetic $ symbol and use NumberFormat().
http://cflib.org/udf/decimalRound

You could create your own UDF to leverage this:

<cfscript>
function DollarFormat2(num){
if (val(num) GT 0){
return "$" & trim(NumberFormat(decimalRound(num, 2, "up"), '999,999,999,999.00'));
} else {
return "-$" & trim(replace(NumberFormat(decimalRound(num, 2, "up"), '999,999,999,999.00'),'-',''));
}
}
</cfscript>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.