Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2007
    Posts
    1

    Unanswered: Summarizing a formula field

    Hi

    I hope somebody will be able to help. Being part of a lab I constantly have to report on turn around times (TAT). I have a problem adding formula fields.

    I have include an attachement to explain my problem. A brief explanation: this report calculates the TAT for sheets (Group of samples) completed for that week. It calculates the Max TAT, 95th percentile, 80the percentile , 50the percentile and the total number of samples for that week.

    Week Max TAT 98th 95th 50th Nr of samples
    2006/11/13 6 6 1 0 38

    When you drill down on a week the completed sheets will be displayed for that week.

    Sheet TAT Nr of samples per sheet Formula
    W017373 6 5 5
    W017516 0 9 0
    W017540 1 5 0
    TOTAL 5
    I would like to TOTAL (sum)the formula coloumn.

    The formula that I have used - looks at samples that have a TAT greater than 2 and returns the number of samples for that sheet.

    I want to Calc the percentace samples that where greater than 2 days.

    How can I add the formula coloumn and if I do have this total can I use it to calc the percentage (5/38) x 100 = %

    I would appreciate if somebody could help me or tell me another way to do this.

    Regards
    Natascha
    Attached Files Attached Files

Posting Permissions

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