LedgerTransactions.DDate     LedgerTransactions.Amount 

11/01/2009                                            1000.00  <--Calculate

12/02/2009                                            1000.00  <--Calculate

12/02/2010                                            1000.00  <--Calculate

12/02/2010                                            1000.00  <--Calculate = TotAmount

12/02/2011                                            1000.00

12/02/2011                                            1000.00

 

This is based on transactions for Company A.  I want to calculate the sum of all transaction for a certain date eg. Only for 2009. In principle the Total will be 4000.00 I've already got the Date which is {@Last_Month}.  The place where I'm stuck is where it neads to step through each record.

 

Explenation:

 

// Get record

// If LedgerTransactions.DDate <  {@Last_Month} then

   Add to totalAmount then NExt record

// Else next record

//Exit Loop, Return TotalAmount

 

 

 

 

Thanks, Im getting the correct TotalAmount when it is in my Details Section but then it shows it above every record.  I only need it to show once at the top. 

 

I've dragged it to my GH1 but then it returns only the 1st value in my Amount table and not the TotalAmount.

 

Possible Solution 2: Formula

 

I've struggle with this formula saying that it excecutes more than it should, infinite loop.. Do you maybe no where my fault is?

 

Dim Balance As Number

Do
    If {LedgerTransactions.DDate} < {@Last_Month} Then
           Balance = Balance + {LedgerTransactions.Amount}
           NextValue ({LedgerTransactions.DDate})
    Else
        NextValue ({LedgerTransactions.DDate})
    End if
Loop Until OnLastRecord = True

Formula = Balance