Return to FileMaker.com
I have tried several things to get this from giving me all the digits as seen in pic.
1. I formatted using the number format.
2. This is a look up field and I tried to us the Round(field;2) and it didn't work.
1. That should work so long as you do not have the cursor in the field at the time you want to see the rounded value.
2. Exactly how did you try to use that expression? It should also work, but the devil is in the details.
Retrieving data ...