count if value in two columns are the same

[#1]

Hi,

I have a hierarchy data set and there are cases where parent level and child level are sharing the same value.

There are two things that I want to do with that.

1. count the number of rows that share the same value for PARENT  and CHILD

2. actually filtering for those rows so that I can bring them in to excel file.

for the first question I was thinking about writing something like

count( distinct if ( PARENT = CHILD), PARENT)

but it does not seem to work.

and for the second one I have no clue at the moment.

Please help!

Thank you!

[Clever_Anjos · Accepted solution]

Maybe

Sum(

     If( PARENT = CHILD, 1, 0 )

)

[ankali1990]

Hello,

you could create flags in the script and after that to sum them in the layout. I prefer to do that instead of sum(if()).

Regards

[abhi1693r]

Hi Stephan,
I had a similar issue. So I have two columns, PART AND CUBES, with one to many relationship.(one PART can have many CUBES or a PART can have no CUBE).
Scenario: If I select 3 PARTS which have 2 CUBES, wherein 2 PARTS have 2 CUBES and 1 PART has no CUBE. I want a count of all the CUBES plus any PART which has no CUBES.

PART	CUBES
SW1001	1415TV
DC1003	1516TD
BW1002

So the count should be 2+1=3.
How can I implement this?

Regards,
Abhishek