AnsweredAssumed Answered

Too many decimal places for calcuation result in my table view

Question asked by inalaop on Mar 3, 2010
Latest reply on Mar 3, 2010 by inalaop

Title

Too many decimal places for calcuation result in my table view

Post

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

Outcomes