Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Feb 25, 2016 11:07 pm**

Work is not ready to upgrade to the new version yet, so for now we are still using 2015.3.

For Cash Sales, I count the number of items using

{Count(DataBand1, Rpt_SalesRegisterDetails.AmountDue == 0 ? 1 : 0)}

For Charge Sales, I count the "non-cash" items

{Count(DataBand1, Rpt_SalesRegisterDetails.AmountDue != 0 ? 1 : 0)}

Currently, all of our transactions are Cash Sales, so there should be 0 showing for Charge Sales.

Did I write the code correctly?

Posted: **Fri Feb 26, 2016 8:26 am**

Hello.

Maybe you should use Sum function instead of Count?

Also you could use CountIf function:

{CountIf(DataCategories, Rpt_SalesRegisterDetails.AmountDue != 0)}

Thank you.

Posted: **Fri Feb 26, 2016 7:00 pm**

CountIf worked great!

Thanks.

Posted: **Mon Feb 29, 2016 6:19 am**

Hello, Joe.

We are always glad to help you.
Let us know if you have more questions.

Thank you.

Count not working in 2015.3