Problem formatting percents

[Jason Goldsmith]

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

[comment]

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

[Jason Goldsmith]

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 November 9, 2023 by Jason Goldsmith

[LAIRY]

Hi,

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

G

[Jason Goldsmith]

My calculation field result is a number.

[comment]

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

 

[Jason Goldsmith]

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

[comment]

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.