Hi,

In filemaker we like to round amounts like 12.42 to 12.40. This is done 
in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3 
and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.

So

12.41=12.40
12.42=12.40
12.43=12.45
12.44=12.45
12.46=12.45
12.47=12.45
12.48=12.50
12.49=12.50

Is someone able to help me in making a calculation for this?

Thanks
 

"Rob" <rob@home.nu> wrote in message
news:41361c4e$0$148$e4fe514c@dreader18.news.xs4all.nl...
> Hi,
>
> In filemaker we like to round amounts like 12.42 to 12.40. This is done
> in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3
> and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.
>
> So
>
> 12.41=12.40
> 12.42=12.40
> 12.43=12.45
> 12.44=12.45
> 12.46=12.45
> 12.47=12.45
> 12.48=12.50
> 12.49=12.50
>
> Is someone able to help me in making a calculation for this?
>
> Thanks
>
>

A simple fix to Lee's solution from yesterday...

 = Round( NumberField / 0.05, 0) * 0.05

Rob wrote:
> Hi,
> 
> In filemaker we like to round amounts like 12.42 to 12.40. This is done 
> in some parts of Europe. There 1 and 2 cents are rounded down on 0; 3 
> and 4 cents are rounded up to 5; 6 and 7 down on 5 and 8 and 9 up to 10.
> 
> Is someone able to help me in making a calculation for this?

Multiply the field by 20, round it to nearest whole number, then divide 
by 20.

e.g. (from memory, I forget if it is round() or truncate(), don't have 
access to FM right now)

RoundedField = Truncate(amountField * 20) / 20