Did you play with set decimals? Also you may try
round(myCalcField, 2)
>How can I limit the number of decimal places printed on the report for calculated fields?
>
>For instance, when I use JobItem.Qty*JobItem.Price on a report textbox, it wants to print many decimal places, but I only want 2 decimal places.
>
>When I use formatting like '999.99' I am always frustrated, because I do not know how big the number will be, so I have to guess how many digits to allow for on the left side of the decimal. I hate having to hard-code liek that. Maybe the result will require '999999.99', but if i make it that big it will print '******.**' on the report becuase the textbox is not big enough to hold all that.
>
>My point is that I want to contrain the number of digits on the RIGHT side of the decimal, but allow as many places to the LEFT of the decimal as required, without me having to tell it how many to allow for.
>
>Do that make sense?
>
>I have also experimented with TRANSFROM, but I still couldn't really get what I was after.
>
>Maybe I need a user function?
If it's not broken, fix it until it is.
My Blog