In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to extract policy basis on Net sum

prpanw
8 - Asteroid

Hi Folks,

I have databaset where Policy numbers and net amount in the sheet. How to extract those polcies where sum of net is 0 but  Same policy can have multiple rows with Net amount and it could be cross match. for example below policy has 3 rows where 2nd and 3rd sum is 0. So I need that rows. it can match 1st and 3rd row as well.

Poliyc      Net

A                299

A                  99

A                -99



 

2 REPLIES 2
binuacs
21 - Polaris

@prpanw one way of doing this with the cross join 

image.png

Qiu
21 - Polaris
21 - Polaris

@prpanw 
By Cross match, you mean for the example below, " 99" can be matched twice with "-99"?

Poliyc      Net

A                299

A                  99

A                -99

A                -99

Labels
Top Solution Authors