Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look at this thread: How to get Equation and value R when I marked Linear in Trendlines
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