Conditional Summing in a Group

trademark16 · Post by **trademark16** » Wed Aug 03, 2011 8:14 pm

Is it possible to sum a column in the Group Footer based on a condition? The formula I tried is below:

{IIF(AccrualExpense.RowType == "Accrual", Sum(AccrualExpense.JanAmt), 0)}

What I want is if the row type = Accrual then use the amount ( in this case January amount), if not the use zero. Hoepfully summing only rows of that type. This did not work for me.

Any ideas? thanks.

Post by **Ivan** » Fri Aug 05, 2011 4:52 am

Hello,

Can you please send us a sample report template with data, which reproduces the issue?
These files will help us to analyze problems and provide you with recommendations for solving the issues.

Thank you.

trademark16 · Post by **trademark16** » Fri Aug 05, 2011 8:07 am

Sure, where can I email the files to? I prefer not to put company financial information on the web.

Post by **Andrew** » Sun Aug 07, 2011 12:26 pm

Hello,

Please files to support@stimulsoft.com. Please refer to this e-mail thread when sending files.

Thank you.