Running Total with a Max
Have a timesheets table and it helps with accruing Paid time off. I need to implement a policy that PTO will max out at 160 hours in a running total field. The running total field looks like t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'm not sure I completely understand why you need to queries to get to your totals, but maybe it has something to do with the placement of the brackets. Maybe try this
Min(
160,Nz(SumValues(GetRecords($QONE),193))+
Nz(SumValues(GetRecords($QTWO),193))
)