如何添加正在运行的总计列取决于gridview中的另外两列? [英] How to add a running total column depends on another two columns in gridview?

问题描述

我有一个包含3栏事件下降存款的简单gridview，
我想在此列中添加另一列BALANCE，如果DROPS为正值，则应在DEPOSIT中求和；如果DROPS为负值，则应从BALANCE列中减去此值，这应按降序进行(从下到上)
听到的是示例gridview

Hi,

I have a simple gridview with 3 columns EVENT DROPS DEPOSIT,
I like to add another column BALANCE in this column if DROPS is a positive value it should sum in DEPOSIT if it''s a negative value it should minus from BALANCE column this should be done in descending order(Bottom to top)

Hear is the sample gridview

EVENT 	BALANCE   DROPS   DEPOSIT
DROP	$1200	  $00	    $00
DROP	$200	  $1000     $00
DROP	$0	  $200	    $00
Remove	$157	  $00	    $-157
DROP	$57	  $100	    $00
DROP	$37	  $20	    $00
DrOP	$17	  $20	    $00
DrOP	$2	  $15	    $00
DROP	$00	  $2	    $00
Remove	$40	  $00	    $-40
DROP	$27	  $13	    $00
DROP	$17	  $10	    $00
DROP		  $17	    $00

在此先感谢

Thanks in Advance

推荐答案

1200

00

00 DROP

这篇关于如何添加正在运行的总计列取决于gridview中的另外两列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！