madvalpreston
Technical User
Hi
we ahve a group in one of our reports on odernumber
I have a formula in to count in
COUNT({BAQReportResult.OrderHed.OrderNum})
This gives me a result of 8, but we have only 6 rows. I believe the ordernum may be repeated for extra order lines
Is there away to just count it once for each order number, sort of a distinct count.
Thanks
we ahve a group in one of our reports on odernumber
I have a formula in to count in
COUNT({BAQReportResult.OrderHed.OrderNum})
This gives me a result of 8, but we have only 6 rows. I believe the ordernum may be repeated for extra order lines
Is there away to just count it once for each order number, sort of a distinct count.
Thanks