I seem to be having problems figuring out the order to list things in an IF statement in Crystal XI.

 

I basically want the text "Auto debit Credit" to appear if the Counterparty is counterparty number 2254 or 1103 and the currency is anything other than GBP or if the counterparty is counterparty number 1208 or 1140 and the currency is GBP.  Otherwise If the amount is negative (the @REC/PAY formula = "PAYMENT) and the counterparty is classified as external (The Cparty.Deal_Int field = "N") I want the field to display The counterparty code, currency and deal type - otherwise if the c.party deal_Int field = "Y" I want the field to display the Facility name - but if this is ="NONE" to display the Deals.CP_Ref field.

 

This is what I have written....However none of the External coding part seems to have worked as they all come back blank and the only part that seems to have worked is the first couple of lines.

 

Your help would be very much appreciated!!

 

If {DEALS.CPARTY}="2254" or {DEALS.CPARTY}="1103" and {diaryrpt.CCY}<> "GBP" then "Auto Debit Credit" else if {DEALS.CPARTY}="1208" or{DEALS.CPARTY}="1140" and {diaryrpt.CCY}="GBP" then "Auto Debit Credit" else If {@REC/PAY}= "PAYMENT" then if {cparty.DEAL_INT}="N" then {cparty.CODE} & {diaryrpt.CCY} & {diaryrpt.TRANS_TYPE} else if {FACILITY.NAME}="NONE" then {DEALS.CP_REF} else {FACILITY.NAME}