linest_m problem

[Anonymous]

I've an histogram chart.

The data I'm using are number of failure for month.

This is a simply example of data :

Jan: 1

Feb: null (no failure on Feb.)

Mar: 2

This is the function:

=linest_m(aggr(sum(QryFailure), Month), aggr(QryFailure, Month)

the function return 1 because not consider the null value of Feb.

but I've 0 failure on Feb and then I expect a coefficient that considering the values 1, 0, 2.

the correct result is 0

How can I do to have the correct value?

[Frank_Hartmann]

did you solve this problem? i´m facing the same problem right now.

[Anonymous]

I solve this problem with a new import select.

In SQL select I create (with a union) a record for each month with the QtyFailure value to Zero.

The new recordset is:

Jan: 1

Feb: null (no failure on Feb.)

Mar: 2

Jan: 0

Feb: 0

Mar: 0

now the linest_m function return the right value.