Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

Hi @amitsingh88 

 

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

amitsingh88
8 - Asteroid

Thanks😊

Labels