It seems like this should be doable.....?
The layout in design mode looks like this:
The top right field (gBalancePerStatement) is a user input field.
The two fields below ($$DepositTotal and $$CheckTotal) are correctly calculated to be $155 and $1110 respectively.
The problem lies with gEndingBalance which is a global calculated field defined as:
It seems that all the pieces are there..... 10000 - (gBalancePerStatement) - 1110 ($$CheckTotal) + 155 ($$DepositTotal = $9045
Got any ideas of what is going on? What am I missing?