Use round Function and have zeros
Hi, I am new to filemaker and cant seem to get this situation solved:
I am doing batting averages, and want to have it in this format .xxx with the x's being the calculation.
I have the round function with my formula in the inside and the precision set to 3.
I get numbers like .435 and .543 but when it is an even round it shows up like .5
I want it to show up as .500 instead of .5 . How do I do this?
Enter layout mode
Select the data tab in the inspector
Click your field to select it
At the bottom of the data tab, you can specify number formatting with a fixed number of decimal places such as 3 in this case.