Running Total with a Max

Dan,

I have solved a similar problem on Time Off, but attack it differently.  There is a Pipeline running monthly that expires the oldest earned time that exceeds the threshold.  It also checks seniority and will raise the threshold on an individual basis from the new hire level out to five years when employees max out.

I solved something similar a few years ago using a three table structure, so we could use relationships: 

1. Employee {Parent},
2. Yearly (calendar) Hours (child), 
3. Time Off Requests (child)

On the Yearly Hours table the employee inputs yearly balance record, Year and Starting Balance, so we can subtract as request records are 'approved'. I query to the sibling table based on the Year (Start Date and End Date) values to get the 'approved' hours. Then on the Time Off Request record we can show the estimated hours taken, and remaining balance. 

If you're comfortable with your query structure, then you can always use report formulas to see where they might be wrong. As Mark pointed out, the inputs/parameters to the Min() seem a bit off, but without knowing your intent it's difficult to say. If you're attempt is to get the first value of query one, and if null, then query two, it should be this: 

Nz(
    SumValues(
      GetRecords($QONE),
      193
    ),
    SumValues(
      GetRecords($QTWO),
      193
    )
)

If not, and you truly want to add the value of these two queries together within the NZ function, where does the trailing zero, 0, come into play?

edit - I see, you're adding either the value of QTWO or 0 to QONE so long as this result isn't null. Which field is 193?

Min(
  160,
  Nz(
    SumValues(
      GetRecords($QONE),
      193
    )
    +
    Nz(
      SumValues(
        GetRecords($QTWO),
        193
      ),
      0
    )
  )
)

Here are some screenshots of using report formulas, and what the resulting report looks like (just a sample of the report). Because I'm already calculating remaining balance, if I sum it, then it's per record for the query params. 

.