In my SSRS 2005 Report I have 5 calculation fields added to my table Group and they are:

=IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) (the Label is Field1)

=IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) (the Label is Field2)

=IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0) (the Label is Field3)

=IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, 0) (the Label is Field4)

=Fields!FeeGoal_AZ.Value \ Fields!FeeSchedule.Value (the Label is Field5)

I want to take SUM(Fields 1-4) \ Field 5. Is there a way to reference fields already in your report that you added earlier?

I tried to do this also below but it doesn't work:

=SUM(IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, 0)) (Fields!FeeGoal_AZ.Value \ Fields!FeeSchedule.Value))