Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this graph where I want to count duplicate bank accounts but ignoring the Efecto. Right now I only manage to count the duplicate accounts on each Efecto. Can somebody help me?
I am using this:
Count ({<[Anulado] = {'0'}>} IBAN)
{<[Anulado] = {'0'}>} = It's another filter I'm using
Hi @goddamnoise
Try like below
Count: Count(Total<IBAN> IBAN)
Duplicate: If(Count(Total<IBAN> IBAN) > 1, 'Y', 'N')