SASO
unread,Sep 10, 2012, 11:59:54 AM9/10/12You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hi all,
I have a table with a field operation (+, -, S). I would build a DataWindow expression that makes this below.
qta operation total_qta
5 + 5
2 + 7
2 - 5
10 S 10 (NOTE reset cumulativesum)
2 - 8
My compute expression total_qta
cumulativesum(if( operation = '+' , qta,if (operation = '-', qta * -1, if(operation ='S',set comulativesum to value or reset, 0) )) for group 1)
Any ideas?
thanks in advance