Pivot Table: 2 Calculated Field Formulas Don't Work

[drmingle]

I need to get the following formulas which are on a spreadsheet to translate into a calculated field in the pivot table.

These two formulas work fine within the spreadsheet:

{Original Working Spreadsheet Formulas}
Formula 1:
=GETPIVOTDATA("Sum of Standard Reimbursement Amt",$A$16,"Payor Group","004 - Hospice")/((GETPIVOTDATA("Sum of Tot Charges",$A$16,"Payor Group","004 - Hospice")/GETPIVOTDATA("Sum of Tot Charges",$A$16,"Payor Group","004 - Hospice","IP/OP","I "))*GETPIVOTDATA("Sum of Total Cases ENB",$A$16,"Payor Group","004 - Hospice","IP/OP","I "))

Formula 2:
=GETPIVOTDATA("Sum of Standard Reimbursement Amt",$A$16,"Payor Group","004 - Hospice")/GETPIVOTDATA("Sum of Tot Charges",$A$16,"Payor Group","004 - Hospice")

These where my attempts to reproduce the same results as above. I am not looking for absolute references per se. The below formulas ignore the conditional argument I attempted to create. The 2nd formula is completly wrong (and probably should not be included).

{Attempt At Calculated Field In Pivot Table - Not Working}
Formula 1:
=IF('IP/OP' ="O ","""",'Sum-Standard Reimbursement Amt'/'Sum-Tot Charges' )
The issue with this formula is that it ignores the conditional argument and produces a result ber line. The desired result is to generate a result where "I" or "O" is not present in IP/OP pivot filed.

Formula 2:
=IF(OR('IP/OP' ="I", 'IP/OP' ="O"),"",( 'Sum-Standard Reimbursement Amt'/(( 'Sum-Tot Charges'/ 'Sum-Tot Charges')* 'Sum-Total Cases ENB'))

Any help would be appreciated...