Jump to content
Sign in to follow this  
Jredeemer14

Calculation Field formatting as decimal

Recommended Posts

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

Share this post


Link to post
Share on other sites

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).

Share this post


Link to post
Share on other sites

See if this helps:

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.