This content has been marked as final.
Show 6 replies

1. Re: Rounding a calculation field
philmodjunk May 14, 2015 1:33 PM (in response to AndrewJudd)Use a constant for the field such as:
Round ( H * 0.03937 ; 1 )
to round it to one decimal place

2. Re: Rounding a calculation field
AndrewJudd May 14, 2015 1:38 PM (in response to AndrewJudd)Thank you, how would i round it to the nearest quarter or half? So 2200mm gets 86.5 for example..?

3. Re: Rounding a calculation field
philmodjunk May 14, 2015 4:05 PM (in response to AndrewJudd)Int(Number) + Choose(Int(Mod(Number, 1) /.25), 0, .25, .50,.75)
This is from a KnowledgeBase article: http://help.filemaker.com/app/answers/detail/a_id/3125/kw/round

4. Re: Rounding a calculation field
AndrewJudd May 14, 2015 4:13 PM (in response to AndrewJudd)Thanks, yes I found that but haven't managed to get the formula quite correct, it says too many parametres or too many ( etc.. This is what I have.. is it close?
Int (H*.03937) + Choose (Int (Mod (H*.03937, 1) / .25, 0, .25, .50, .75)

5. Re: Rounding a calculation field
philmodjunk May 14, 2015 4:25 PM (in response to AndrewJudd)Int (H*.03937) + Choose (Int (Mod (H*.03937, 1) / .25), 0, .25, .50, .75)

6. Re: Rounding a calculation field
AndrewJudd May 14, 2015 4:30 PM (in response to AndrewJudd)Thank you