using multiple IIF formulas
Posted: Thu Apr 21, 2016 3:53 am
i can't get this IIF formula to work, am I missing something
{IIF(cq1.TradeDescription=="CAPITAL LEASE",cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="DEBTS AT SUBS LEVEL
",cq1.Pre_Swap_Debt_Total/Debts_at_Subs_Level.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="JV FINANCINGS",cq1.Pre_Swap_Debt_Total/JV_Financings.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="DADE COUNTY BOND",cq1.Pre_Swap_Debt_Total/Dade_County_Bond.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="OTHER CORPORATE DEBTS
",cq1.Pre_Swap_Debt_Total/OTHER_CORPORATE_DEBTS.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="SENIOR NOTES
",cq1.Pre_Swap_Debt_Total/SENIOR_NOTES.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="Revolving Credit Facility - 550 USD
",cq1.Pre_Swap_Debt_Total/Revolving_Credit_Facility___550_USD.Post_Swap_Debt_Total_Sum),"-"))))))))}
{IIF(cq1.TradeDescription=="CAPITAL LEASE",cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="DEBTS AT SUBS LEVEL
",cq1.Pre_Swap_Debt_Total/Debts_at_Subs_Level.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="JV FINANCINGS",cq1.Pre_Swap_Debt_Total/JV_Financings.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="DADE COUNTY BOND",cq1.Pre_Swap_Debt_Total/Dade_County_Bond.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="OTHER CORPORATE DEBTS
",cq1.Pre_Swap_Debt_Total/OTHER_CORPORATE_DEBTS.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="SENIOR NOTES
",cq1.Pre_Swap_Debt_Total/SENIOR_NOTES.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="Revolving Credit Facility - 550 USD
",cq1.Pre_Swap_Debt_Total/Revolving_Credit_Facility___550_USD.Post_Swap_Debt_Total_Sum),"-"))))))))}