I have a for loop process for a BO where I find items and for each item I calculate one column value.
That value equals one formula + all previous calculated values from the looped items based on date.
1
3 (1+2)
7(4+3)
15(7+8-)
so 2 and 3 and 8 are calculated from formula and 1 and 4 and 7 are previous all values sum.
I tried to put it in a process in a loop but because of this and that it does not give me correct values.
I wanted to avoid stored proc and use process logic but its not working.
process 1
Find BO where value is undefined ORDER BY date1 ASC and then call second step process
4 items found
Process 2 BO is passed
BO .value=SUM BO .value where date1<BO.date1+myformula this just does not work
