Page 1 of 1

using multiple IIF formulas

Posted: Thu Apr 21, 2016 3:53 am
by laducd
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),"-"))))))))}

Re: using multiple IIF formulas

Posted: Thu Apr 21, 2016 6:51 am
by Alex K.
Hello,

Please check the following expression:

Code: Select all

{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,"-")))))))}
Thank you.

Re: using multiple IIF formulas

Posted: Thu Apr 21, 2016 12:28 pm
by laducd
The formula is working but for some reason some are showing the false response even though there is a trade description that equals.

Re: using multiple IIF formulas

Posted: Thu Apr 21, 2016 12:28 pm
by laducd
The formula is working but for some reason some are showing the false response even though there is a trade description that equals.

Re: using multiple IIF formulas

Posted: Fri Apr 22, 2016 10:01 am
by HighAley
Hello.

Please, send us your report template with sample data.
We need to reproduce the issue to help you.

Thank you.

Re: using multiple IIF formulas

Posted: Tue Apr 26, 2016 5:26 pm
by laducd
The information is confidential, can we jump on a Webex

Re: using multiple IIF formulas

Posted: Tue Apr 26, 2016 7:25 pm
by Jan
Hello,

Sure, can you send the request via Email to support@stimulsoft.com?

Thank you.