2 Replies Latest reply: Jun 25, 2013 3:11 AM by Marco van der Have RSS

    Need check of expression

      Hi Community,

       

      I got the following Code:

       

       

      =SUM({<Companyname = , TransactionDate = {">=(=MIN(TransactionDate)$<"} OpeningBalanceAmount)

      Should display the openingsamount of the first TransactionDate

       

      =SUM({<Companyname = , TransactionDate = {">=(=MAX(TransactionDate)$<"} ClosingBalanceAmount)

      Should display the closingamount of the lastTransactionDate

       

      What is wrong with the code? It keeps returing empty.