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.