using multiple IIF formulas

[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),"-"))))))))}

[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.

[laducd]

The formula is working but for some reason some are showing the false response even though there is a trade description that equals.

[laducd]

The formula is working but for some reason some are showing the false response even though there is a trade description that equals.

[HighAley]

Hello.

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

Thank you.

[laducd]

The information is confidential, can we jump on a Webex

[Jan]

Hello,

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

Thank you.