5 Replies Latest reply: Jun 25, 2013 10:45 AM by Marco van der Have RSS

    Select previous value

      Hi,

       

      I got the following code:

       

      =SUM({<Accountnumber=, CompanyName=, CalendarDate={'$(=Minstring(CalendarDate))'}>}OpeningBalanceAmount*DebitCreditFactor)

      This code gets met the value of OpeningBalanceAmount of the first date selected and multiplies it with DebitCreditFactor.

       

      But not all dates got an OpeningBalanceAmount. Is there a way for me to select the previous OpeningBalanceAmountif no OpeningBalanceAmount is found in the selection.

       

      Example:

       

      CalendarDateOpeningBalanceAmount
      01-01-2013 200.00
      01-02-2013-
      01-03-2013-
      01-04-2013

      220

       

       

       

      If i select date 01-03-2013 it must return the value of 01-01-2013.

       

      Kinds regards,

       

      Marco