how to calculate the intersection point x axis y axis values and display the output
Hi all,I have an ongoint set of data where the x axis is date and y axis is the CRM index. I would like to calculate when the line will hit the lower and upper "green zone". I can do it by formulating through fit y by x and create a prediction formula column and enter the date manually to next empty data row and try and try but I guess there is a better way of doing it. This would also be extremel...
