Hi!
Hope you can help.
I am trying to use the Count function in expressing calculated fields on Q-pulse. So far, I am not getting anywhere, what I want is something as basic as the COUNTIF function on Excel.
For example, I would like the report to count the number of fields that show a date that is less than today’s date (e.g. overdue review documents)
This is how I have set it up:
![](https://uploads-eu-west-1.insided.com/ideagen-en/attachment/db37d908-b198-48a4-bc32-84898641c422.png)
![](https://uploads-eu-west-1.insided.com/ideagen-en/attachment/7e944a5d-007d-48d4-b64b-48dc79a4f5f7.png)
But it only prints an empty box. Am I doing something wrong? I’ve tried putting it in every single band.
It would be helpful to have more in-depth guides for report designer!
Thank you!
Best answer by Sam Jackson
View answer