Finding the slope

[#1]

attached is the picture of my dashboard. As you can see in the graph the linear formula which refer to the gradient is correct

but in the table it shows a different value

formula used in the table is =linest_m(finalMean,TQuarter)

where TQuarter is referred as  dual(Quarter,AutoNumber(Quarter) as TQuarter

PLEASE HELP

[Nicole-Smith]

Have a look at this thread: How to get Equation and value R when I marked Linear in Trendlines

[#3]

Actually Nicole i did an if statement for Quarter to be referred as numbers and that give the correct answer.

That means when i use the  dual(Quarter,AutoNumber(Quarter) as TQuarter its not doing in correct way which cause a problem.

For the mean time i can make if statements which match quarter to a number, but for the sake of learning i need to understand what was wrong in my formula. Thank you for the support

Sincerely

Bilal

From the ARAB World