5 Replies Latest reply: Jul 6, 2011 10:40 AM by Michael Lüttgering RSS

    Problem with SET ANALYSIS and input field

      Hello all,

       

      I need help for a problem with the set analysis function. I have a table with customer number, a creation date of an invoice and a field with the value of the invoice.

      For the users I like to create a input box, where there can input a date. Then I like to have a sum of the invoices from the customer where the creation date is less or equal as the date in the input box.

       

      I have defined a variable in the document (FDatum) and create a input box for this variable. The database field called: OffenePostenHistorie.BELDATUM

      The invove value field called: OffenePostenHistorie.OBETRAG

       

      I have used the following set analysis function, but it doesn't work:

       

      sum({$<OffenePostenHistorie.BELDATUM <= {$(FDatum)}>} OffenePostenHistorie.OBETRAG)

       

      The format of the date in the table is YYYYMMDD and I put a date with the same format in the input box.

       

      Can anybody give me a hint whats wrong?

       

      Thanks in advance.

       

      Michael