Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need two decimal places

JSRunnels
in Calculation Engine (Define Fields)

Featured Replies

I know this must have a very easy answer, but I can't seem to get it to work...

I want a calculation field to show two decimal places -- even if they are zeros. The field sums two number fields. If the sum is "7", I want it to return "7.00".

This is a simple, simple invoice. I have tried Round, Truncate and SetPrecision. It always returns "7".

I know there must be an easy way to do this, but somehow I am missing it.... I have searched FMForums for decimals, cents, steprecision. No luck....

Please help!

Make the result of your calculation field a Number. In Layout mode, select the field and choose Format > Number... from the menu. Select "Format as decimal", and check "Fixed number of decimal digits: 2".

  • Author

Thank you.

I knew it would be easy. I just spent an hour trying to figure it out!!!

I love FMForums.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.