//  Returns true for the selected month
If
    mailto:%7b@May - {@May } = 1
Then
    Sum ({ACCOUNTING_BALANCE.AMOUNT_BALANCE})
else
    0;
If the month for the current record is 'true' that is it is equal to May add it to the sum otherwise don't . I have made running totals for several months each checking the condition eg. April, May but they all return the same value. Any thoughts?

 

//  Returns true for the selected month
If
    {ACCOUNTING_BALANCE.ACCOUNTING_PERIOD} = 11
Then
    1
else
    0;
If the value in the above field is equal to "11" this expression returns true. Now all the rows that are true should be sum with the following result.

     March              April                May

      5,348            3,444             55,000

 

The numbers in each of the above colums may represent the sum of 300 row sum up by months.

 

 

http://www.kenhamady.com/form11.shtml - www.kenhamady.com/form11.shtml

 

This article says that you don't need the If-Then sytax just a straight boolean like:

 

{ACCOUNTING_BALANCE.ACCOUNTING_PERIOD} = 10

 

I tried this and it worked. I could still use some help with default values in dynamic parameters.