Hi, I am playing with the Scan function. The goal is to "reset" sum at rolling months, of my choice. The problem is in this function: =SCAN(0;t_salg[Beløp];LAMBDA(a;b;IF(K3#<>M2;a+b;0*a+b))) I guess the problem is the K3# dynamic refference. Is it possible? Please see the attached document as an example. Best RegardsGeir

Forum Discussion

Steel Contributor

Feb 15, 2023

Solved

Hi,

I am playing with the Scan function. The goal is to "reset" sum at rolling months, of my choice.

The problem is in this function: =SCAN(0;t_salg[Beløp];LAMBDA(a;b;IF(K3#<>M2;a+b;0*a+b)))

I guess the problem is the K3# dynamic refference.

Is it possible? Please see the attached document as an example.

Best Regards

Geir

Perhaps this:

=SCAN(0,t_salg[Beløp],LAMBDA(a,v,LET(k,SEQUENCE(ROWS(t_salg)/3,,3,3),IF(XOR(ROW(v)=k),v,a+v))))