Creating reports and dashboards | Stimulsoft community forum

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.

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.

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

Hello,

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

Thank you.