4 Replies Latest reply: Mar 30, 2013 8:53 PM by LEWIS GOLDSTEIN RSS

    Determining intersection date of two Expressions

      I've got two Expressions charted on a line chart.  I want the date on which the 2nd Expression is >= the 1st Expression, which I will then display in a Straight Table.  I've created a simplified example below.  Hoping someone can tell me how to create an Expression for my Straight table that will return this date.

       

      First Expression is: 

      TOTAL_TB - (TOTAL_TB * 0.25)

       

      Second is simply:

      T30_AVG_USED_TB

       

       

      SAMPLE TABLE::

      DISC_DATE

      TOTAL_TBAVG_USED_TB
      2003-01-02150100
      2003-01-03150109
      2003-01-04150120
      2003-01-05150125
      2003-01-06150133

       

      In this example I would want 2003-01-04, as the first expression calculates out to 112.5, hence 120 is first occurance of AVG_USED_TB >= 112.5.