Sum of openings per unique reqs

Content

Hi,

I have a report that returns multiple lines per req when there is more than one work location. This is expected, but each line then has one open position. So, if there is a requisition with one open position, but for four work locations, then it sums four open positions.

As a result, when summing positions open it is overstating the actual amount.

I tried using "Running Sum", but this is not working for me. What is the best way to calculate the correct open positions in this situation?

Thanks,

Glenn