How to extract policy basis on Net sum
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
prpanw
8 - Asteroid
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Fuzzy Match
2 REPLIES 2
binuacs
21 - Polaris
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@prpanw one way of doing this with the cross join
21 - Polaris
Sunday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
