I have this expression that works fine:
=IIF(Fields!Interest_Only_Flag.Value ="Y",IIF(Fields!Loan_Type.Value = "Residential HFI 5YH", "28",
IIF(Fields!Loan_Type.Value = "Residential HFI 3YH", "27", IIF(Fields!Loan_Type.Value = "Residential HFI 7YH", "29",
IIF(Fields!Loan_Type.Value = "Residential HFI 1ML", "26", IIF(Fields!Loan_Type.Value = "Residential HFI 6ML", "25",""))))),"")
I need to add this part: (the 'N' part):
=IIF(Fields!Interest_Only_Flag.Value ="N",IIF(Fields!Loan_Type.Value = "Residential HFI 5YH", "18",
IIF(Fields!Loan_Type.Value = "Residential HFI 3YH", "17", IIF(Fields!Loan_Type.Value = "Residential HFI 7YH", "19",
IIF(Fields!Loan_Type.Value = "Residential HFI 1ML", "16", IIF(Fields!Loan_Type.Value = "Residential HFI 6ML", "16",""))))),"")
I need the above two expressions to work together...guessing I can't use both at same time?