Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    34

    Unanswered: Calculation in Report

    I want to add a percentage of throughput into my report. So I have 2 columns;
    Checked & Failed

    My control looks like this:
    =100-[Failed]/[Checked]

    If I use "Percent in the format control I get a return something like this, 9993.18%
    However if I use "Standard" in the format control I get a return of 99.3 (no percent symbol with it) which is closer to correct, just no % symbol.

    How would I write this to return the Percentage as xx.xx?

    Thanks,
    Don........

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Code:
    =1-[Failed]/[Checked]
    Format as a percentage.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Oct 2007
    Posts
    34
    Thank you.
    Don...........

Posting Permissions

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