2 Replies Latest reply: May 22, 2017 5:51 AM by Ofer Elrom RSS

    Using max and min selection dates

    Ofer Elrom

      Hi QV community,

       

      I would really apreciate any help regarding an issue I encountered.

       

      I have a data set containing the following:

       

      EventDateEventValue1EventValue2
      01/01/201611
      02/02/201622
      03/03/201610
      04/04/201611
      05/05/201601
      06/06/201620
      07/07/201611
      08/08/201610
      09/09/201601

       

      I need to display the sum of EventValue1 below max selection date minus sumof EventValue2 below min selection date.

       

      I tried verious combinations but nothing seems to work for me.

       

      Thanks in advance.