SumIfRunnig

Stimulsoft Ultimate discussion
Post Reply
papinaser
Posts: 9
Joined: Mon Jul 13, 2015 7:43 am

SumIfRunnig

Post by papinaser »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: SumIfRunnig

Post by HighAley »

Hello.

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

Thank you.
papinaser
Posts: 9
Joined: Mon Jul 13, 2015 7:43 am

Re: SumIfRunnig

Post by papinaser »

Hi.
But I have a filter in DataBand, and I want to use SumIfRunning without considering filter in DataBand.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: SumIfRunnig

Post by HighAley »

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.
Post Reply