7 Replies Latest reply: Apr 11, 2011 5:56 AM by AnnikaBorg RSS

    set analysis calculation based on selection


      The end user wants to select a date and then count sales based on calculations around that date.

      e.g. use selects a date, the user wants to see sales for the dates before the selected date.

      I'm thinking a set analysis of course but i don't know how to write it when it comes to the date to be calculated around.

      This is roughly expressed of how i want to do, script-wise;

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

      Thanks in advance