Linest_M & Linest_B do not work

[#1]

Dear All,

Could you please look into the attachment and find out the issue why the functions Linest_M & Linest_B do not work?

Thanks,

Dong

[Gysbert_Wassenaar · Accepted solution]

Your Month field contains text values, not numbers

See what happens if you turn those into numbers:

LINEST_M(#Cust.,Match(Month,'Jan','Feb','Mar','Apr','May','Jun')-1)

LINEST_B(#Cust.,Match(Month,'Jan','Feb','Mar','Apr','May','Jun')-1)

[#3]

Thanks you so much.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

[#5]

Sorry for that cause I am new for this forum.

I just marked it is correct answer

Thanks

[oknotsen]

All good. That is why I posted my reply .

Enjoy the community!

Onno

Qlik Community Team member