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.