by Brian_Houghton » Sat Oct 29, 2011 9:09 am
Hi Charles,
Thanks for following up. In theory you should be able to do the following, but I haven't tested it recently (I seem to think I did it in the past):
1. Add a calculated field that adds the value of the integer/float field to the previous value of the current calculated field. This will create a running total, much like you would expect in a checkbook ledger but in the reverse (checkbook balances seem to get smaller, don't they!). Then use a relationship to pull in the value from the last field in the calculated field column. It will pull it in as plain text, so if you need to use it in any calculations you'll need to add another calculated field to your main database that multiplies the value times 1 and returns it as an integer or float value.
Hope this helps!
Kind Regards,
Brian Houghton, DDH Software