Distinct count on a group

[madvalpreston]

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

 

[madvalpreston]

Please ignore this post of course the DISTINCTCOUNT works.

Thanks

 

[jlopeman]

is this Epicor?

 

[madvalpreston]

I am using a crystal linked inot Vantage (epicor), but the question was relating to Crystal.