Jump 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 help in Field calculation

mskichu
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

hi anyone

I have field which stores floating point Numbers. For example, after calculations this field stores the value 25.20 like 25.2 I want to store like 25.20 is there any way I can do it

thanks

mskichu

www.crazytips.com

Trailing zeros are not stored in number fields. You can make it display trailing zeros by formating the field as a decimal number. If you want to store trailing zeros make it a text calculation. A case function may the easiest way to do this.

  • Author
  • Newbies

Thanks ralph

I have tried in case structure but I have also find easier way to do this

I have set the property of the field format as two decimal it worked out.

In windows

Right click on the field in the layout

click Number format and set decimal value to 2

anyway thank you very much

Create an account or sign in to comment

https://fmforums.com/topic/25723-need-help-in-field-calculation/
Go to topic listing

Important Information

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

I accept

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.