Too many decimal places for calcuation result in my table view
I have a relatively simple date calculation (called "Months") which is the number of months since I last saw a client.
The calculation I am using is:
(( Get (CurrentDate)) - (Last Seen)) / 30
Where "Last Seen" is the date I last saw them.
The calculation works fine, and in Browse mode, I can limit the number result to 1 decimal point (by going into the 'number format' setup).
However, in table view I'm getting a number with 7 decimal places; such as 17.5666667. I just want for example 17.6 so show up in the table view.
I couldn't find a way to limit the decimal places in Table view, so is there a way to modify my calculation formula to do this?? Or am I missing a way to limit the decimal places in the table view?
Thanks
Actually, I just figured this out;
This is an actual table view layout of my data. Seems I just needed to click on 'form view' for this and then I was able to click on the calculation field and use the 'number format' setup.