I like what you've done here. I've played with a for a bit, and am seeing that it seems to work some clicking sequences and not in others.To try to tease it out, I put a FINAL reference in a text box on the Final layer, to see if that was causing the problem. And I think it might be.
I need to run out now, and I haven't quite figured out WHERE it is, but:
- Let' say I leave all items blank (set to 0) EXCEPT for personal gifts and clothing, and for purchases per week I type in a 1.
- And, let's call the Submit buttons from left to right (in preview mode) Submit 1, 2, 3, 4
- If I click Submit 1, then Submit 2, then Submit 3, then Submit 4, the Final (in the reference box I've placed on the layer) Shows as 0.
- But, if I click Submit in other sequences, e.g., 2, 3, 4, 1 or 3, 4 1, 2 or 2, 4, 3, 1. Final (the tota)l displays correctly.
When I play with the other items I yield similar results but with different sequences of clicking Submit buttons. Pretty much, it seems if I first hit the Submit button that comes AFTER an item, that item's "full" reference shows as 0.
So, I I only enter a quantity in one of the boxes and:
So for iTunes, if I hit Submit 2, 3, 4, 1, Full = 0.
For Coffee if I hit Submit 3, 4, 1, 2, Full=0
For Lunch if I hit Submit 4, 1, 2, 3, then Full = 0
Wish I had another few minutes. Curious now!