formula help

[laducd]

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

[Alex K.]

Hello,

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

Thank you.

[HighAley]

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.

[laducd]

it worked

[Alex K.]

Hello

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

Thank you.