Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Reset value cumulativesum

43 views
Skip to first unread message

SASO

unread,
Sep 10, 2012, 11:59:54 AM9/10/12
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

bruce.a...@yahoo.com

unread,
Sep 24, 2012, 12:38:50 PM9/24/12
to
Although this group is active on the Sybase server the feed between Google and the Sybase server is not currently working. If you post through Goolge the post will never show up on the Sybase server, and most people who answer questions in that group will never see it. Instead, you may want to access the Sybase newsgroups directly at:

http://www.sybase.com/detail_list?id=11507&pageNum=1&multi=true&show=1248
0 new messages