Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have been using the Linest_R2 for the first time , I do understand it gives the co relation between 2 values.
I have the y and x values which are to be considered within Linest_R2 function as sum(y) and sum(x) , but when i apply this i get an error stating nested aggregation is not allowed.
So could someone guide me how sum(y) and sum(x) values be used within Linest_R2 function
Does anyone have any suggestions for the above Query
try this:
=LINEST_R2(total aggr(Y,X),X)
or
=LINEST_R2(total aggr(sum(Y),X),X)
hope this helps