Determining intersection date of two Expressions

[#1]

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_TB	AVG_USED_TB
2003-01-02	150	100
2003-01-03	150	109
2003-01-04	150	120
2003-01-05	150	125
2003-01-06	150	133

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. 

[udit_kumar_sana]

Hi ,

Please find here the attached file for the solution.

Regards,

Udit

[#3]

Hello Udit,

Thanks for your response and sample solution. I understand what you are doing here, but does not fully solve my problem as I only want to display the Intersection Date in my Straight Table and nothing else.  Any ideas?

Thanks,

Lew 

[udit_kumar_sana · Accepted solution]

Hi,

Please see the attached file.

-Hide the two expression column from presentation tab of straight table by choosing hide column option available.

Regards,

Udit,

[#5]

Thanks!  This did the trick!

Best Regards,

Lew