Hello! I have problem with the following expression of linest_m() and aggr():
LINEST_M
( totalaggr(
RangeSum( above( sum(if(TYPE=TYPE_01 ,1,0))
,0, RowNo()) ) ,DT_TIME_05)
,DT_TIME_05
)
The aggr() cumulates the result of sum() with DT_TIME_05. Actullay, this does return a result but the result is not correct, which means it does not correspond the regression line drawn by:
RangeSum( above( sum(if(TYPE=TYPE_01 ,1,0))
,0, RowNo()) )
I think the problem might be that aggr() returns a group of datas that are not in order of DT_TIME_05.
Does anyone have any idea about this problem? Thank you so much for your response!!!