Help with nested formula

[laducd]

I have the following formula to sum the groups.

{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 I would like in the footer is the sum of those groups
{Sum(((((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)),"-"))))))}

I can't get the sum to work in my footer

[Alex K.]

Hello,

Please try to use the Totals.Sum() function.

Thank you.

[laducd]

Like this

{Totals.Sum(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)),"-")))))))}

[laducd]

it game me a crazy number

[Alex K.]

Hello,

Please send us a simple report with test data for analysis.

Thank you.

[laducd]

the info is confidential, can we jump on a call

[laducd]

the info is confidential, can we jump on a call

[Alex K.]

Hello,

We do not need your working data, you can send us a test data and report template on support@stimulsoft.com

Thank you.