1 Reply Latest reply on Mar 3, 2010 9:15 PM by inalaop

    Too many decimal places for calcuation result in my table view

    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