Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    10

    Unanswered: % Percent format problems?

    When using the percent format for a table field the data is coming back mutiplied by 100.

    for example.

    I would like to input 50% but the table auto changes this to 5000%

    I have tryed all the field sizes which dont make a difference.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the formatting fucntion multiplies by 100, ie 1 is displayed as 100%, .1 as 10%, .01 as 1% etc....
    so you need to adjust you percentage calculation accordingly

    effectively use
    percentval=(cellvalue/popvalue)
    instead of
    percentval=(cellvalue/popvalue)*100

Posting Permissions

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