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

    Difference between dates in set analysis


      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!