Post reply

Two Expressions - IF/THEN logic

  • September 1, 2009 at 9:47 am

    #210390

    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?

  • September 2, 2009 at 11:42 am

    #1048315

    I would try using the switch function for the "Y" and "N", and nest the IIFs inside the switch. I'm not positive it would work, but it's worth a shot.

    Edited: check out the 3rd post on this thread. It has an example you may be able to leverage.

    http://qa.sqlservercentral.com/Forums/Topic558383-150-1.aspx

    Hope that helps,

    -Marianne

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply