Text Form Field Calculation
Hello all,
I have a budget form where I want to calculate the expenditure and income, with a total of what's left. I have set up text form fields (E1 to E38 for expenditure which is on the first page and I1 to I8 which is on the second page), but they are not calculating. I have calculated on exit and have the following formulas in the Expression boxes:
Page 1 - E1 to E38
Page 2 - I1 to I8
Page 2 - Incoming (Expression =Sum(E1:E38))
Outgoing (Expression =Sum(I1:I8))
Total (Expression =Incoming-Outgoing))
I hope this makes sense! And I can't work out why it's not working! Any help would be greatly appreciated!
Ta muchly, folks!
|