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.

Problem formatting percents

Featured Replies

Hi,

I have a simple calculation field that consists of a fraction. The numerator and denominator are both number fields. On my layout, I've formatted the calculation field as a percent with a fixed number of decimals of "2". 

The result is decimal (not a percent), and the decimals are not fixed to 2 but instead have 16 numbers following the decimal. I've tried formatting the field as decimal with a fixed number of 2, and get the same result (16 numbers following the decimal).

I've tried with and without storing calculation results.

Any suggestions?

Thank you,

Jason

39 minutes ago, Jason Goldsmith said:

Any suggestions?

It is hard to make useful suggestions without being able to reproduce the problem. You don't even say what your input values are.

Does the attached work as you would expect?

 

 

FractionAsPercent.fmp12

  • Author

Hi comment,

Your solution works fine. My calculation field, input fields, and data formating on the layout are exactly the same as yours. This is as simple a calculation as it gets. 

The input fields are numbers, for example, 10 for the numerator (in a number field) and 20 for the denominator (also in a number field). 

Jason

 

Edited by Jason Goldsmith

Hi,

Is your calculation field specified with résult as "number" (and not text) ?

G

  • Author

My calculation field result is a number.

17 minutes ago, Jason Goldsmith said:

My calculation field, input fields, and data formating on the layout are exactly the same as yours.

Could you post your file (preferably a copy with everything else removed)?

 

  • Author

Here are screenshots of the setup. The calculation field in question is "IOP Reduct"

Screenshot 2023-11-09 at 7.08.17 PM.png

Screenshot 2023-11-09 at 7.10.34 PM.png

Screenshot 2023-11-09 at 7.12.09 PM.png

I am afraid I am not talented enough to tell what's wrong with your file by looking at pictures. I suggested you post a file that demonstrates the problem.

 

Create an account or sign in to comment

Important Information

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

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.