AnsweredAssumed Answered

show seconds with decimals

Question asked by ZWW on Feb 13, 2018
Latest reply on Feb 14, 2018 by bigtom

For the Olympics speed skating, I made a table with distances, round numbers, round times and results.

I use FMP16.0.4.403  in a MBP with OSX HighSierra 10.13.3

I want to see the decimals of the seconds, but I see the decimals only if the cursor is in the field.

See attachment.

For the fields of the round times I used the numbers format with two decimals, which shows the decimals.

The field  of the result is a calculated field with time format.

In the inspector I set the Result field on time mmss with leading zeros for mm and ss, after that I moved from time to decimal and set fixed decimals to 2 and separator on ".".

 

Now I can see the decimals, but only if the cursor is in the field. If the cursor is not in the field I see zeros instead of the true decimals.

 

Is there a solution ?

 

Many Thanks

Ernest

Attachments

Outcomes