If the percentage is 0.6666666, do you want 66 or 67?
Assuming 67, you can use either the round function in your calculation to round the value to a specified number of decimal places or you can use data formatting to display the value formatted with 0 decimal places. Either result displays the same value, but keeping the value unrounded in the calculation field may be the better option if you also need to use this result in other calculations.
You can either multiply by 100 to turn 0.67 into 67 or you can use the same data formatting in the inspector to specify a percent format.
Hey Phil - Thanks for responding to my post. I really have no idea to do what you said. In my fields description I have Percentage set to calculation. And the calculation is: Made / Attempts
I don't know what else to do to get it to Round and then display as 100 times the amount. And, yes, .6888888 would need to be 69.
Round ( Made / Attempts * 100 ; 0 )
Made / Attempts * 100
But then, when you put it on your layout, go to the data tab of the inspector and scroll down to data formatting. Withe the field still selected, specify a decimal with 0 decimal places.
Since this is a shooting percentage, you can also use:
but specify a percent value in data formatting with 2 decimal places. This will display a 2 out of 3 result as:
Thank you. That does exactly what I need it to do. Thank you for your time!