Number formatting 1

[hassellhorse]

Is there a way to custom format a number so that it will round up to the next dollar even if it's less than a half dollar. For instance if I have $40.03 I want it to round up to $41.00 and if I have 40.52 I want it to round to $41.00. Thank you.

 

[lbass]

If you CR XI, you can use the roundup function. Otherwise, you can use:

-int(-{table.number})

-LB

 

[synapsevampire]

Try:

int(round({table.field}+.499999))

-k

 

[synapsevampire]

Ahh, much cleaner, *LB*, I always forget that one...!

-k