Remainder = Abs ( normalHours ) - Abs ( whole )Īnd then you would use that calculation field in the List function, instead of your normalHours field.In keeping with the principle, “Why use a screwdriver, when I have this hammer right here?”, I decided, instead of just downloading a free utility from the Mac App Store, I would build folder creation functionality using FileMaker Pro Advanced 17. New calculation fieldĪlternately, if you don't want to automatically modify the existing number, you could make a new calculation field with a very similar calculation: Let ( [ This should then come through your List() function later.

This will append a '.00' to any whole numbers in your field. You could change your normalHours field to be an auto-enter calculation, uncheck 'do not replace existing value', and set the calculation to the following: Let ( [ Please let me know if I can provide any further information that might help.Ī few things you can try: Auto-enter calculation replacing existing value In both cases I still see plain integer output for whole numbers and no trailing zeroes in any case. $$normalHours = SetPrecision( List( laborTable::normalHours ) 2 ) I've tried using SetPrecision(hours 2) when populating the field, and also (though I didn't think it would actually work) when creating my list variable: This is normally trivial via Inspector -> Data for a single-value field, and perhaps it still is trivial - but I'm just not seeing it. The issue is that I would like to always display the hours field with two decimal places: Jim Jones 8.00 2.00 The field height needs to be dynamic because there could be anywhere from 1 to 10 or so employees displayed. The hours are all calculated fields pulled from another table, but they need to be stored numerically.Įach column has its own text field: | > | > | > |. The data being displayed is a list of employees who worked on a particular job on a particular day, and the number of hours they worked under various classifications (normal, overtime, non-billable, non-billable overtime, et al).

I'm using List() to retrieve a numeric field which I subsequently display on a report view via a merge variable inside a text field.

Filemaker pro 17 phone number format