I am dealing with a table that holds a field for the opening balance of an account at the start of a year and then in a semi colon delimited field lists the period balance (i.e. net change) of that account for each month of the year. On the report I would like to display the current balance for the account which would mean I would have to sum up all of the values in the semi colon delimited field and add the sum to the opening balance.
My question then is how to parse the field to separate out each of these period balance values. Thanks for any help.

Thanks! The single formula worked.