Good day,
I hope I am posting this in the correct forum.
I am working on a claim file. I have attached an example.
Each claim number has multiple line numbers associated with it in a separate record on my spreadsheet. I have been able to use Power Query to sum all of the line numbers for each claim, with no problem.
Here is the twist, I want to isolate those claims that have a particular line item. But I still need the total claim value including all the line items. In short, I know there is a problem with how this particular line item is adjudicated. Any claim without it is noise.
If this is not the correct forum I apologize. I would appreciate being directed to the correct forum if possible.
Thank you in advance for any assistance.
Bookmarks