I'm trying to create a consolidating trial balance in Crystal Reports version 11, accessing the data through Lawson database tables. I would like to create a formula field for 15 months, for the periods Jan 1, 2010 through Mar 31, 2011. How do I create the formula since it crosses over two years?

Here is an example of the formula used to report for 12 months ending Dec 31, xxxx.  I would like to add 3 months of the next year to it.

Thank you!

({GLAMOUNTS.CR_BEG_BAL}+{GLAMOUNTS.DB_BEG_BAL}+
{GLAMOUNTS.CR_AMOUNT_01}+{GLAMOUNTS.DB_AMOUNT_01}+
{GLAMOUNTS.CR_AMOUNT_02}+{GLAMOUNTS.DB_AMOUNT_02}+
{GLAMOUNTS.CR_AMOUNT_03}+{GLAMOUNTS.DB_AMOUNT_03}+
{GLAMOUNTS.CR_AMOUNT_04}+{GLAMOUNTS.DB_AMOUNT_04}+
{GLAMOUNTS.CR_AMOUNT_05}+{GLAMOUNTS.DB_AMOUNT_05}+
{GLAMOUNTS.CR_AMOUNT_06}+{GLAMOUNTS.DB_AMOUNT_06}+
{GLAMOUNTS.CR_AMOUNT_07}+{GLAMOUNTS.DB_AMOUNT_07}+
{GLAMOUNTS.CR_AMOUNT_08}+{GLAMOUNTS.DB_AMOUNT_08}+
{GLAMOUNTS.CR_AMOUNT_09}+{GLAMOUNTS.DB_AMOUNT_09}+
{GLAMOUNTS.CR_AMOUNT_10}+{GLAMOUNTS.DB_AMOUNT_10}+
{GLAMOUNTS.CR_AMOUNT_11}+{GLAMOUNTS.DB_AMOUNT_11}+
{GLAMOUNTS.CR_AMOUNT_12}+{GLAMOUNTS.DB_AMOUNT_12})

How do I add the corresponding fields for a different year to the existing formula?  The formula I have currently starts with the beginning balance of the year selected (such as 2010 from the parameter field), then adds the 12 periods for the year (Jan-Dec).  How do I add to the formula so that the system picks up the 12 periods Jan-Dec 2010, and also include periods Jan-Mar 2011?  Thank you for your assistance!

The formula in the first post starts with the beginning balance from the GLAMOUNTS table (CR represents Credit and DB represents Debit - both are needed to include the positive and negative amounts to arrive at the beginning balance).  The remaining periods represent the corresponding month's credit and debit values.  CR_AMOUNT_01 & DB_AMOUNT_01 represent the credit and debit database amounts for Jan, respectively.