Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed May 11, 2016 5:16 pm**

The following IIF formula worked but for some reason it has stopped.

This is an emergency, is there anyway we can jump on a call

{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_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum,IIF(cq1.TradeDescription=="JV FINANCINGS",cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_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,"-")))))))}

Posted: **Thu May 12, 2016 7:21 am**

Hello.

Please, try to use one stich instead of multiple IIF functions. Your expression will be next:

Code: Select all

{Switch(
	cq1.TradeDescription=="CAPITAL LEASE", cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum,						
	cq1.TradeDescription=="DEBTS AT SUBS LEVEL", cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum,
	cq1.TradeDescription=="JV FINANCINGS", cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum,
	cq1.TradeDescription=="DADE COUNTY BOND", cq1.Pre_Swap_Debt_Total/Dade_County_Bond.Post_Swap_Debt_Total_Sum,
	cq1.TradeDescription=="OTHER CORPORATE DEBTS", cq1.Pre_Swap_Debt_Total/OTHER_CORPORATE_DEBTS.Post_Swap_Debt_Total_Sum,
	cq1.TradeDescription=="SENIOR NOTES", cq1.Pre_Swap_Debt_Total/SENIOR_NOTES.Post_Swap_Debt_Total_Sum,
	cq1.TradeDescription=="Revolving Credit Facility - 550 USD", cq1.Pre_Swap_Debt_Total/Revolving_Credit_Facility___550_USD.Post_Swap_Debt_Total_Sum,
	true, "-"
)}

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Multiple IIFs

Multiple IIFs

Re: Multiple IIFs