Count amount of duplications - with conditions

yanivbm88 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to find amount of duplications within a database, based on certain columns with conditions.

Below is a sample of the data I have:

Duplications column should follow the below guidelines:

Show the total amount of times each combination of VednorCode and ItemName appears.
- Amount in each line refers to VendorCode and ItemName in the same line.

Columns where one of the following happens should not be counted:
- ItemName is '6357'
- VendorCode is 'H03000785'.

I am already familiar with Count(TOTAL <VendorCode, ItemName> ID) as a solution, but I want to add conditions to it.

Any ideas?

Re: Count amount of duplications - with conditions

vinieme12 — Sun, 04 Jun 2017 18:35:35 GMT

Try below

Count({<ID = e({<ItemName ={6357}>+<VendorCode={'H03000785'}>} ID) >} TOTAL <VendorCode, ItemName> ID)