Linest_R2 Function Usage

[anushree1]

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

[anushree1]

Does anyone have any suggestions for the above Query

[Frank_Hartmann]

try this:

=LINEST_R2(total aggr(Y,X),X)

or

=LINEST_R2(total aggr(sum(Y),X),X)

hope this helps