View Single Post
 
Old February 1st, 2006, 03:56 PM
dba123 dba123 is offline
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Working with fields already in my SSRS 2005 report

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