LINEST_M function set analysis help

[saumyashah90]

Hi All,

I have

=if(LINEST_M(Metric_Value,Dt)>=0,LINEST_M(Metric_Value,Dt))

I have StartDate and EndDate Variable and i want above expression with start date and enddate in it.

How can i do that.

Dt is my Date column

[saumyashah90]

any 1?

[swuehl]

Try something along these lines

LINEST_M({<Dt = {">=$(StartDate)<=$(EndDate)"}>} Metric_Value,Dt)

assuming that your variables are formatted to match the format of your Dt field values.

[saumyashah90]

Yeah i tried this before also,

But when i change dates in calendar,

out put doesnt change

[swuehl]

I assume it's just a formatting issue, i.e. the format of your variables.

Try

LINEST_M({<Dt = {">=$(=Date(StartDate,FORMATCODE))<=$(=Date(EndDate,FORMATCODE))"}>} Metric_Value,Dt)

where you need to replace FORMATCODE with an appropriate format code to match format of field Dt, e.g. 'YYYY-MM-DD', or post a small sample that demonstrates your issue.