1 Reply Latest reply: Oct 1, 2009 4:47 PM by Neil Miller RSS

    Data set analysis

    rey-man

      Hi all,


      i've got this statement:


      Sum (
      {1<
      Calendar.Week={$(=Max(Calendar.Week))}
      >}
      NetSales
      )


      But now i want to also include the CalDate:

      The result has to be the sum of NetSales for the max week but smaller or equal than the day selected

      So I thought is was something like this:



      Sum (
      {1<
      Calendar.Week={$(=Max(Calendar.Week))},

      Calendar.CalDate={$(<=(Calendar.CalDate))}
      >}
      NetSales
      )



      But this aint working correct.
      Can anybody help me?

      Tnx in advance

      Reyman

        • Data set analysis
          Neil Miller

          Give this a try:

          Sum({1<Calendar.Week={$(=Max(Calendar.Week))},Calendar.CalDate={'<=$(=Calendar.CalDate)'}>} NetSales)


          I pulled the less than or equal out of the dollar-sign expansion and put the whole Set Modifier in quotes.

          The easiest way to test Set Analysis is to put your expression into a chart, but don't give it a label. On the chart, the label for that expression will be the Set Analysis expression with the dollar-sign expansion evaluated.