Matching Linest_b and linest_m values with the auto generated trend line
I have attached my sample qvw file.
As an example i have hard code the linest value for application CWT. the autogenerated graph shows very different values from the one calculated using linest functions. For the months that are having zero values the trend line should be shown as negative line but the graph that i have generated using linest show positive value. Also the final values dont seem to match at all.
I think it is something to do with the way dates should be written for 'x'.
I have tried to convert it into num..
Can anybody please help as to what I need to change in my expression ?
