+ Reply to Thread
Results 1 to 1 of 1

Problem with a calculated field in Pivot

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    boston
    MS-Off Ver
    2013
    Posts
    2

    Problem with a calculated field in Pivot

    Hi,

    I am trying to calculate yield from a column (P/F) that has only 0s (Pass) and 1s (Fail)
    In Pivot, I can easily make a field that has Sum(P/F) and Count(P/F). I have confirmed that Excel is counting the 0s and 1 correctly)

    For yield, I would take (Count(P/F)-Sum(P/F))/Count(P/F) to get yield, but no matter how I try to do it within the Pivot (i tried using claucalted field) it doesnt come out with correct calcualtion and I am not sure why.

    Any ideas?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  2. [SOLVED] Calculated Field Problem in Pivot Table
    By CM_Marsh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-16-2013, 09:10 AM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. Pivot Calculated Field Problem
    By B Glass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2012, 11:29 AM
  5. Problem with calculated field in Pivot table
    By BigPat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-27-2008, 04:25 AM
  6. Pivot Table Calculated Field Problem
    By headly in forum Excel General
    Replies: 1
    Last Post: 06-08-2006, 10:55 PM
  7. [SOLVED] pivot table formulas for calculated field or calculated item
    By Vicky in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 12:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1