Forum Discussion
Solved
Reset the Scan function with a condition.
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))) ...
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))))
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))))- Perfect. Thank you.
- You're welcome!
