Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Get sum by filtering on two columns

amitsingh88
8 - Asteroid

I need to print the sum of all total investment values in 2016 (TIV_2016), to a scale of 2 decimal places, for all policy holders who meet the following criteria:

  1. Have the same TIV_2015 value as one or more other policyholders.
  2. Are not located in the same city as any other policyholder (i.e.: the (latitude, longitude) attribute pairs must be unique)

I tried this with no success.

 

Also suggest the Python script to get the result if possible.

 

Please help.

 

Thanks

 

 

 

6 REPLIES 6
atcodedog05
21 - Polaris

Hi @amitsingh88 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1634633730358.png

 

Hope this helps : )

 

amitsingh88
8 - Asteroid

Hi,

 

The answer is 45. Latitude and Logitude condition is not met.

 

 

Thanks

atcodedog05
21 - Polaris

Hi @amitsingh88 

 

Sorry, misread the condition. Here is how you can do it.

Workflow:

atcodedog05_0-1634644121774.png

 

Hope this helps : )

amitsingh88
8 - Asteroid

Hi,

 

Workflow is not complete. I think you have attached wrong workflow.

 

Thanks

atcodedog05
21 - Polaris

Hi @amitsingh88 

 

Updated the post with the right workflow. Sorry about that.

amitsingh88
8 - Asteroid

Thanks😊

Labels