November 9, 20232 yr 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
November 9, 20232 yr 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
November 9, 20232 yr 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 November 9, 20232 yr by Jason Goldsmith
November 9, 20232 yr Hi, Is your calculation field specified with résult as "number" (and not text) ? G
November 9, 20232 yr 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)?
November 9, 20232 yr Author Here are screenshots of the setup. The calculation field in question is "IOP Reduct"
November 9, 20232 yr 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