AnsweredAssumed Answered

Rounding up to the nearest Eighth

Question asked by vraughn on Mar 15, 2018
Latest reply on Mar 15, 2018 by fmpdude

Hi all,
    I currently have Filemaker 12 Pro and right now I'm trying to write a script that rounds up to the nearest Eighth, I've read some other discussions on the matter but the scripts I find just round to the nearest not the next one up. I'm thinking of using a combination of Ceiling and round but so far I haven't made it work.

Here is the script I'm currently using it rounds to the nearest eighth.

(Int( (((SQlength+.3)*SQnumberofpieces)+1) ) + Choose(Int(Mod( (((SQlength+.3)*SQnumberofpieces)+1) ; 1) /.125); 0; .125; .25;.375;.5;.625;.75;.875))

 

If I put ceiling in the front I get a whole number, I still want decimals.
Thanks.

Outcomes