Calculation Field formatting as decimal

[Jredeemer14]

I'm sure there is a simple solution but here is my situation. I have a couple calculation fields that I need formatted to 2 decimal places. I have them formatted in the layout but I didn't realize that because they are calculations fields, they are not being outputted in the actual calculation to 2 decimal places and it is screwing up math later on when I'm trying to use them in currency formatted fields.

So basically how to I format a field that is a calculation to output a number to 2 decimal places. Any help would be appreciated. Thanks

[mr_vodka]

Well since its currency I guess you would want it round it to the nearest hundreth.

If so, use Round(YourField; 2).

If not, you can use Truncate(YourField; 2).

[comment]

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/195904/