Rounding Up

[Herbs]

We are using FileMaker for all aspects of our business but one area has me stumped.

When we purchase our product it can be any size from 1m2 to 5m2 in increments of 10cm.

I have the calculations set up to calculate longest length and longest width which works fine but in terms of pricing as soon as it goes over a size (eg: 900 to 910) we get charged the 1000 rate.

How do I get this to work in FileMaker as rounding rounds down below 0.5 and floor/ceiling just doesn't work in a repeating field or accurately.

Any suggestions?

[Wim Decorte]

What calculation are you using now, we can use that as the basis for tweaking.

 

Why use repeating fields in this case, can you expand a bit on that?

[mr_vodka]

Hi Herbs.

 

First I would ask why are you using repeating fields for true data. Second, a copy of your calculation or sample file would be great as we dont really have a context to help you right now. Once you do that we can try to help identify the issue for you.

[Herbs]

I have sorted now thank you.

The reason we are using repeating field is there can be up to 25 different panels for each customer so this keeps it neater.

The formula if anyone is interested is:

Round (field + 0.0499999 ; 1)

[mr_vodka]

Seems like a convoluted way to solve the issue which we still dont know. As for your reasoning for the repeating fields, you could achieve the same thing with related records, which would be the more proper way.

[Lee Smith]

With some exceptions, Repeating Fields were pretty much replaced by relationships when they were introduction in FileMaker v3.  

 

if you were to do a search of this Forum, you would find several threads advising against using repeating field for things other than graphics for UI, and for the most part has been explained by FileMaker in their Tech Article Link