Working with fields already added to Report

• dba321

  Hall of Fame

  Points: 3917

  More actions

  February 1, 2006 at 12:54 pm

  #113278

  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))

• Hugh-294034

  SSC Rookie

  Points: 29

  More actions

  February 2, 2006 at 12:21 pm

  #618474

  You might want to try this with a CAST Convert Function.  This can give you the functionality of the SWITCH command in access