This is a public Forum  publicRSS

Forum post

    inalaop
    Too many decimal places for calcuation result in my table...
    Forum post posted March 3, 2010 by inalaop , last edited February 9, 2012
    503 Views, 1 Comment
    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

    Answer

     

    • inalaop

      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.