Need to capture a running total at the end of a transform

sendmk · Post by **sendmk** » Tue Mar 28, 2006 2:20 am

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

sendmk · Post by **sendmk** » Tue Mar 28, 2006 2:21 am

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

ArndW · Post by **ArndW** » Tue Mar 28, 2006 2:24 am

Running total is easy. If you have a column In.Col1 that you want a running total on, create a stage variable "RunningTotal" and just assign "RunningTotal + In.Col1" to it and output that to a column.

ArndW · Post by **ArndW** » Tue Mar 28, 2006 2:25 am

Running total is easy. If you have a column In.Col1 that you want a running total on, create a stage variable "RunningTotal" and just assign "RunningTotal + In.Col1" to it and output that to a column.