Find count of a field

[ClowneUser]

Hi,
I have a report that is looking at the rejects that have been made. all info is in one view, contents below:

Transaction ID
Part Number
Date Rejected
Value

Now depending on when the part was rejected there could be multiple values, for example Raw material cost, labour cost, overheads etc..

So in the view the same transaction ID could have multiple entries ( if that makes sense )

on the report i created a group on Part Number, I then did a Count on the Part Number to try to determine the amount of incidents for the part number, this obviously brings back a multiple of the multiple value entries.

Is there a way I can fine the number if incidents?

I'm sorry if I haven't explained myself very well, but any help would be appreciated.

Regards,

Mick.

 

[lbass]

If I’m understanding correctly, insert a distinctcount on Transaction ID at the Part Number group level. This would should the number of transactions per partnumber regardless of multiple values.

-LB

 

[ClowneUser]

LB,
Thanks, I could have sworn I'd tried that, but tried it now and all is working fine.

Thanks for your help.

Regards,
Mick.