If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#54229 by swiftinitpvtltd
Tue Jun 30, 2020 8:55 am
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
#54237 by eagles9999
Wed Jul 01, 2020 1:33 am
Use a Non Persistent BO with While Condition on the BO Rule....

Who is online

Users browsing this forum: Google [Bot] and 29 guests