### Title

Round up calculation result

### Post

I have a file that I use to calculate baskeball stats. One stat is shooting percentage, which would be shots made divided by shots attempted. If a player shoots the ball 6 times and makes two of them, my results are returned as:

.3333333333333333

I would like to return that result as 33. Can someone tell me how to do this?

Another example is, a player has 9 made shots, 13 attempts, comes back as:

.6923076923076923

I would like that returned as 69.

Thanks.

Charlie

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.