Creating reports and dashboards | Stimulsoft community forum

Hi.
I have this table

ID Customer SalePrice State
=====================================
1 Naser 700 OK
2 Papi 400 OK
3 Papi 800 Fail
4 Naser 450 Fail

Now in report I want to show just rows with "OK" State. but in report summery I want have sum of all rows with any state.
I know that I can have sum of all records with SumIfRunnig , but when I write a filter In DataBand in order just showing rows with "OK" State, then SumIfRunnig get sum of filtered rows.
I want to SumIfRunnig do his work without considering filter in DataBand.
Thanks.

Hello.

You could use CountIf() function.
For more information and samples, please, read our User Manual.

Thank you.

Hi.
But I have a filter in DataBand, and I want to use SumIfRunning without considering filter in DataBand.

Hello.

Sorry I didn't get your first question.

Please, try to use Data Source name as first parameter of the SumIf() function.

If this does not help, we need to see your real sample.

Thank you.