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.