Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2014
    Posts
    46

    Unanswered: query calculation precision

    Hi,
    Is there any way to control the precision on a query summary (in particular, "average") calculation? The field has a precision of 1 decimal, but the average always shows at least 6. I can't find a place to specify the summary precision.
    Thanks.
    Don

  2. #2
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    Verify the format of the field. That may help

  3. #3
    Join Date
    Jan 2014
    Posts
    46
    THX spyroot. Format is fine. I cannot believe others have not had this issue. In a query you can set summary information under the appearance | table style | sort and group tab. The field is set to have "average" of the given field displayed which always shows 6 to 14 decimal precision. No way to set this?

  4. #4
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    Can you assign the value of your average field to a numeric field? That way you can control the number of decimals.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •