COUNT function with a Designer report

unknown

Good Thursday.

I have a series of invoices that I would like to count for a customer within a Designer report.

There is a function in Visualizer that allows me to count the number of invoices.

I am new to BQL coding and unable to come up with a solution within Designer, if there is one available.

Any guidance is welcomed.

Find more posts tagged with

Birst - General Discussions

Comments

unknown

David,

The same function that allows you to count invoices in Visualizer will work in Designer. Are you unable to find where you set the measure to Count?

unknown

Thank you Cindy. I see where Visualizer has a count in the "custom summary". I am unable to find the same in Designer. I thought to add the Invoice number in the summary band but that yielded no result.

unknown

If you have a measure that counts Invoices (like if Invoice Number is a measure) you can add that measure to the summary band. Like in this example, I have a list of products with their ProductID, then I put the ProductID measure in the Summary band to get the count:

If you don't have an Invoice Number measure then you can do a STAT expression. Let me know if that's your scenario and if you need help writing the STAT.

unknown

Thank you. I looked for a measurement that I could count. Unfortunately that is not available. My attribute is [Invoiced Order Details.IVNO]. I attempted to write a STAT function and it appears my BQL programming abilities are limited. Any guidance that you can provide is most appreciated.

Copyright © 2025 Infor. All rights reserved.