Creating reports and dashboards | Stimulsoft community forum

hi

I have the following formula in a Databand.

{IIF(cq1.TradeDescription=="CAPITAL LEASE",(cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,IIF(cq1.TradeDescription=="DADE COUNTY BOND",(cq1.Pre_Swap_Debt_Total/Dade_County_Bond.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,IIF(cq1.TradeDescription=="OTHER CORPORATE DEBTS",(cq1.Pre_Swap_Debt_Total/OTHER_CORPORATE_DEBTS.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,IIF(cq1.TradeDescription=="SENIOR NOTES",(cq1.Pre_Swap_Debt_Total/SENIOR_NOTES.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,IIF(cq1.TradeDescription=="JV FINANCINGS",(cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,
IIF(cq1.TradeDescription=="DEBTS AT SUBS LEVEL",(cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2,"-"))))))}

I would like to get this is a GroupFooter Band as well but I am not getting any data returned. This is what I tried.
{IIF(cq1.TradeDescription=="CAPITAL LEASE",Sum((cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),IIF(cq1.TradeDescription=="DADE COUNTY BOND",Sum((cq1.Pre_Swap_Debt_Total/Dade_County_Bond.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),IIF(cq1.TradeDescription=="OTHER CORPORATE DEBTS",Sum((cq1.Pre_Swap_Debt_Total/OTHER_CORPORATE_DEBTS.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),IIF(cq1.TradeDescription=="SENIOR NOTES",Sum((cq1.Pre_Swap_Debt_Total/SENIOR_NOTES.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),IIF(cq1.TradeDescription=="JV FINANCINGS",Sum((cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),IIF(cq1.TradeDescription=="DEBTS AT SUBS LEVEL",Sum((cq1.Pre_Swap_Debt_Total/Debts_at_Sub_Level_and_JV_Financings.Post_Swap_Debt_Total_Sum)*(cq1.Post_Total_IRS_Rate2))),"-"))))))}

What is incorrect with this formula within my group footer band

Hello,

Please try to use the Totals.Sum() function in your expression.

Thank you.

Hello.

Could you send us your report template with sample data for analysis?
Please, try to use Switch function. It will be more useful in your case.

Thank you.

it worked

Hello

We are always glad to help you!
Let us know if you need any additional help.

Thank you.