机构吃货(源码)
2011-02-19 10:59:00来源:本站整理浏览:317
机构吃货;
N1;1 100 3
N2;1 100 5
N3;1 100 10
b1=IF(ISNULL(BIGBUYCOUNT1[-1]),0,BIGBUYCOUNT1[-1])+IF(ISNULL(WAITBUYCOUNT1[-1]),0,WAITBUYCOUNT1[-1])*0.33;
s1=IF(ISNULL(BIGSELLCOUNT1[-1]),0,BIGSELLCOUNT1[-1])+IF(ISNULL(WAITSELLCOUNT1[-1]),0,WAITSELLCOUNT1[-1]);
b2=IF(ISNULL(BIGBUYCOUNT2[-1]),0,BIGBUYCOUNT2[-1])+IF(ISNULL(WAITBUYCOUNT2[-1]),0,WAITBUYCOUNT2[-1])*0.33;
s2=IF(ISNULL(BIGSELLCOUNT2[-1]),0,BIGSELLCOUNT2[-1])+IF(ISNULL(WAITSELLCOUNT2[-1]),0,WAITSELLCOUNT2[-1]);
吃货:(b1+b2-(s1+s2))/SHGZG*100;
s$1日吃货:SUM(吃货,n1);
s$2日吃货:SUM(吃货,n2);
s$3日吃货:SUM(吃货,n3);