If-Then-Else Statement

[RedSoxRule]

I need to combine these two if-then-else statements but I'm having trouble with the syntax in Cognos. I know how to do it in Access.

If([qry_Facility_Reimbursement_Info].[Direct Pay Site?]='yes') THEN (([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount])-([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount]*[qry_Facility_Reimbursement_Info].[Proration %])) Else null

If([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Type]='DP') THEN (([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount])-([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount]*[qry_Facility_Reimbursement_Info].[Proration %])) Else null

 

[RedSoxRule]

Never mind, I figured it out.

IF(([qry_Facility_Reimbursement_Info].[Direct Pay Site?]='yes') AND ([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Type]='dp'))THEN (([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount])-([qry_Financial_Invoices].[Supplier Inv Upload) Invoice Amount]*[qry_Facility_Reimbursement_Info].[Proration %])) Else null