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.
Conditional Summing in a Group
-
- Posts: 20
- Joined: Sun Aug 29, 2010 2:56 am
- Location: Buffalo, NY
Conditional Summing in a Group
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.
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.
-
- Posts: 20
- Joined: Sun Aug 29, 2010 2:56 am
- Location: Buffalo, NY
Conditional Summing in a Group
Sure, where can I email the files to? I prefer not to put company financial information on the web.
Conditional Summing in a Group
Hello,
Please files to support@stimulsoft.com. Please refer to this e-mail thread when sending files.
Thank you.
Please files to support@stimulsoft.com. Please refer to this e-mail thread when sending files.
Thank you.