9 Replies Latest reply: Feb 28, 2011 11:10 AM by AnnikaBorg RSS

    field equals fields in set analysis

      Hi,
      I can't seem to get my set analysis right here's what i do;

      =sum({<InvoiceActivationDate={$<=(max(pay_date)-7)}>} OriginalPrice)

      So what I want to do is sum OriginalPrice for dates (InvoiceActivationsDate's) that are earlier than the maximum pay_date -7 days.

      I've tried to just write;

      =sum({<InvoiceActivationDate={$(max(date))}>} OriginalPrice)

      but that doesn't work either.

       

      Where do i go wrong?

      Thanks in advance

      //A.