10 Replies Latest reply: Mar 1, 2011 8:44 AM by AnnikaBorg RSS

    Difference between dates in set analysis

      Hi!

      I'm trying to get a sum according to a datefield that decides the activationdate of the invoices to be summarized. I'v got this form a life saver on this forum but it does not work. Any idéas? Or workarounds?

       

       

      =sum({<InvoiceActivationDate={'>=$(=Date(max(pay_date)-21))<=$(=Date(max(pay_date)-14))'>} OriginalPrice)'

       

      Thanks in advance!

      //A.