Get sum by filtering on two columns

[amitsingh88]

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

[atcodedog05]

Hi @amitsingh88 

Here is how you can do it.

Workflow:

Hope this helps : )

[amitsingh88]

Hi,

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

Thanks

[atcodedog05 · Accepted solution]

Hi @amitsingh88 

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

Workflow:

Hope this helps : )

[amitsingh88]

Hi,

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

Thanks

[atcodedog05]

Hi @amitsingh88 

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

[amitsingh88]

Thanks😊