可以说JMP没有将条件求和制作为函数是它的败笔:
只能通过循环来搞定了
dt=New Table("多列条件求和",AddRows(10000));
For(i=1,i<=4,i++,dt<<New Column("X",Numeric,Formula(Random Normal(0,1))));
dt<<delete column(1);
dt<<New Column("正和",Numeric,Formula(Local({i=0,n=N Col(Current Data Table())- 1},Sum(Repeat({i++ ; Column(i)[] *(Column(i)[]>0)},n)))));
dt<<New Column("负和",Numeric,Formula(Local({i=0,n=N Col(Current Data Table())- 2},Sum(Repeat({i++ ; Column(i)[] *(Column(i)[]<0)},n))))); |