参考这个试试 int load_over() { int i,grid_rows; num Profit_1,Price,RefPrice,InpNum; grid_rows = grid_row_num("MG"); //获取报表明细数 grid_add_col('MG','Profit_1','利润',i) //新增【利润】列 for(i=1;i<grid_rows;i++) { Price = grid_get_v('MG','inp_price',i) //获取报表明细【单价】列数据 RefPrice = grid_get_v('MG','factor_in_ref_price',i) //获取报表明细【折算参考进价】列数据 InpNum = grid_get_v('MG','inp_num',i) //获取报表明细【数量】列数据 Profit_1 = (Price - RefPrice) * InpNum //获取【利润】计算值 grid_set_v("MG","Profit_1",i,num_2_grp(num_trim(Profit_1))); //【利润】列赋值,计算结果去掉【小数点后面的0】并添加千分符 grid_set_col_color('MG','Profit_1',16711935) //【设置利润】列字体颜色为【粉红色】 }; grid_mark_sum('MG','Profit_1') //设置【利润】列合计数量 return 1; }; |