2 Replies Latest reply: May 27, 2013 10:23 AM by Hatus Peters RSS

    How to range date field in Set Analysis

    Hatus Peters

      Hi everyone

       

       

      Can anyone help me to figure out how to solve this expression? In a Pivot Table or Straight Tabel

       

      Sum({<Calendar_BookingDate.Datum = {">=$(=PDGroups.PurchaseDate)<=$(=vKeyDate)"}>} PAYMENTS)

       

      Objective: For each Portfolio (dimension = PDGroups.Portfolio), give me the sum of payments between its Purchase Date (only one different date per Portfolio) and one fix key date equal to all data line.

       

      Problem: I get aways the minimum date of all Portfolios. But when I select only one Portfolio, it returns the right sum.

      Interesting is that when I add an expression to the chart with the PDGroups.PurchaseDate alone, it returns the right date per Portfolio regardless the selection.

       

      The Aggr() Function inside this range set didn't work as well.

       

      May any details be missing, pls just let me know.

       

      Thanx in advance.

      HP