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.
SumIfRunnig
Re: SumIfRunnig
Hello.
You could use CountIf() function.
For more information and samples, please, read our User Manual.
Thank you.
You could use CountIf() function.
For more information and samples, please, read our User Manual.
Thank you.
Re: SumIfRunnig
Hi.
But I have a filter in DataBand, and I want to use SumIfRunning without considering filter in DataBand.
But I have a filter in DataBand, and I want to use SumIfRunning without considering filter in DataBand.
Re: SumIfRunnig
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.
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.