Hopefully fresh eyes will offer some insight.

What I'm trying to do is get a total count of "unclaimed" services.

An "unclaimed" service is a service that has a balance of greater than zero and no associated "claim" record.

- @Claimed -
IF ISNULL({CLAIM.ID}) AND SUM({@Balance}) > 0 THEN
    1 //"Unclaimed"
ELSE
    0 //"Claimed"

Balance is calculated by the SUM of each revenue line

 - @Balance -
 {REVENUE} - {PAYMENT} + {TRANSFER} - {ADJUST}

The @Claimed formula is on the group 1 footer and the @Balance formula is within the details. There can be multiple revenue lines, and the sum of each @Balance line is the remaining balance of that service.

The @Claimed formula works as expected - however I need to be able to get a SUM of all the "unclaimed" records (@Claimed) - but you cannot get a Running Total of a Running Total. So I would really appreciate some fresh eyes on the issue. I'm sure I'm attacking this the wrong way.

Report Layout

The report layout is as follows:

Main Service Details
GH1a | Service Date   - Service ID   - Etc
GH1b | {SERVICE.DATE} - {SERVICE.ID} - {ETC}

Service Revenue Line Details 
GH1c | Revenue   - Payment      - Transfer   - Adjustment   - Balance
D    | {REVENUE} - {PAYMENT}    - {TRANSFER} - {ADJUSTMENT} - {@Balance}

Service Revenue Totals
GF1b |  Claimed    - Revenue      - Payments      - Final Balance
GF1c |  {@Claimed} - RT {REVENUE} - RT {PAYMENTS} - RT of {@Balance}

ALL Services Revenue Totals
RFa  | Total Unclaimed - Total Revenue - Total Payments  - Total Balance
RFb  | ???             - RT            - RT              - RT of {@Balance} no reset

RT = Running Total Fields