0

Can I combine CountUnique on two columns?

Hi,

I am trying to write a function that counts all lines with a unique combination of 'posting date' AND 'source no.' By adding some normal filters, it would give me the total amount of sales shipments over a period of time to different customers. Since we often have multiple 'document no.s' on 1 actual shipment, I need to know how many unique combinations of 'posting date' & 'source no.' there are in the table. Is there any way to do this in Jet Reports?

KR Tommie

1 comment

Please sign in to leave a comment.