I usually use a FileMaker custom function called ScientificNotation to round results containing a power of 10 exponent to a certain number of decimal places. However, this can be inconvenient to use at times. I'm still on FileMaker 7 Developer, and I have access to FileMaker 8.5 Advanced. But neither of these versions has an easy way to set the number of decimal places for a result containing a power of 10. I don't know if versions 9, 10, or 11 does.

Example: I would like 3.122411775e-8 (the calculation result) to be displayed as 3.1224e-8. Attempting to use the "number" layout formatting does not help at all. Of course, I can use ScientificNotation but it can be tedious to use when there can be many possible output results for a field, as in a large case statement.

There has been no change in the ways a number can be formatted.

Of course, I can use ScientificNotation but it can be tedious to use when there can be many possible output results for a field, as in a large case statement.

It shouldn't be:

Let ( 

result = Case ( 

...

) ; 

ScientificNotation ( result ; 4 )

)

Ah, I see what needs to be done--instead of Case being by itself in the solution part of Let, set result = Case in the variable definition part of Let and then use the ScientificNotation fuction in the solution part of Let on the variable result. Thanks, Comment.