SSA:=IF(C>REF(C,1),AMOUNT,0);
SSB:=IF(C<REF(C,1),AMOUNT,0);
净流入:=SUM(SSA,0)-SUM(SSB,0);
总额:=SUM(AMOUNT,0);
流入比:(净流入)/总额*100;
版权声明:文章来自网络!方法技巧仅供参考!拾荒网10Huang.CN,财富在手十指紧握!与努力的人共勉!
SSA:=IF(C>REF(C,1),AMOUNT,0);
SSB:=IF(C<REF(C,1),AMOUNT,0);
净流入:=SUM(SSA,0)-SUM(SSB,0);
总额:=SUM(AMOUNT,0);
流入比:(净流入)/总额*100;