Report Designer | Ideagen Community
There's more discussions to explore simply by registering for Ideagen Community. Join us and start speaking with your peers today!
Solved

Report Designer

  • 15 August 2023
  • 1 reply
  • 333 views

Userlevel 2
Badge +2

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: 

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!

icon

Best answer by Sam Jackson 16 August 2023, 16:29

View answer

1 reply

Userlevel 2
Badge +2

Hi Monika,

My name is Sam and I work within the Pre-Sales at Ideagen with prior experience in the Service Delivery side configuring and implementing Q-Pulse in various industries, so I may be able to help you here.

It’s also worth noting that Ideagen can provide Basic and Advanced training courses in the Report Designer software, so it may be worth reaching out to your account manager if this may be of interest to you.

Step 1 - Create a field as you have done and add the below expression:

[Review Date Time] < Today()

This will create a field showing review dates before todays dates
 

Step 2 - Drag and drop that field into the Report Footer. It’s really important it goes into the report or group footer so that it can add up all the records.

Once in the report footer, select the field and then click the little arrow at the top right of the field to access ‘Label Tasks’. If you update the Report Summary to ‘Report’ and Summary Function to ‘Sum’, this should then add up all those values for you.

 

Hopefully the above works for you, but please reach out if you’re still encountering any issues.

Thanks,

Sam

Reply