| | |
| | | ccsvaluesum := ccsvaluesum + ccsvalue; |
| | | } |
| | | sumcolumn := table.FinancialWeeklyColumn( relnew, Name := 'SUM' ); |
| | | cumulantcolumn := table.FinancialWeeklyColumn( relnew, Name := '累计量' ); |
| | | //cumulantcolumn := table.FinancialWeeklyColumn( relnew, Name := '累计量' ); |
| | | proportioncolumn := table.FinancialWeeklyColumn( relnew, Name := '占比' ); |
| | | //SUM |
| | | totalpcellsum := sumcolumn.FinancialWeeklyCell( relnew, Value := [String]( [Number]totalpvaluesum ) ); |
| | |
| | | ccscellsum := sumcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluesum ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellsum ); |
| | | //累计量 |
| | | totalpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalpvaluecumulant ); |
| | | totalproduction.FinancialWeeklyCell( relinsert, totalpcellcumulant ); |
| | | dlpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlpvaluecumulant ); |
| | | dlproduction.FinancialWeeklyCell( relinsert, dlpcellcumulant ); |
| | | ccpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccpvaluecumulant ); |
| | | ccproduction.FinancialWeeklyCell( relinsert, ccpcellcumulant ); |
| | | totalscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalsvaluecumulant ); |
| | | totalsales.FinancialWeeklyCell( relinsert, totalscellcumulant ); |
| | | dlscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlsvaluecumulant ); |
| | | dlsales.FinancialWeeklyCell( relinsert, dlscellcumulant ); |
| | | ccscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluecumulant ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellcumulant ); |
| | | //totalpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalpvaluecumulant ); |
| | | //totalproduction.FinancialWeeklyCell( relinsert, totalpcellcumulant ); |
| | | //dlpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlpvaluecumulant ); |
| | | //dlproduction.FinancialWeeklyCell( relinsert, dlpcellcumulant ); |
| | | //ccpcellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccpvaluecumulant ); |
| | | //ccproduction.FinancialWeeklyCell( relinsert, ccpcellcumulant ); |
| | | //totalscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]totalsvaluecumulant ); |
| | | //totalsales.FinancialWeeklyCell( relinsert, totalscellcumulant ); |
| | | //dlscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]dlsvaluecumulant ); |
| | | //dlsales.FinancialWeeklyCell( relinsert, dlscellcumulant ); |
| | | //ccscellcumulant := cumulantcolumn.FinancialWeeklyCell( relnew, Value := [String]ccsvaluecumulant ); |
| | | //ccsales.FinancialWeeklyCell( relinsert, ccscellcumulant ); |
| | | //占比 |
| | | totalpvalueproportion := guard( ( totalpvaluecumulant / totalpvaluesum ).Format( 'N(Dec(2))' ), '0.00' ); |
| | | totalpcellproportion := proportioncolumn.FinancialWeeklyCell( relnew, Value := totalpvalueproportion ); |
| | |
| | | ccscellproportion := proportioncolumn.FinancialWeeklyCell( relnew, Value := ccsvalueproportion ); |
| | | ccsales.FinancialWeeklyCell( relinsert, ccscellproportion ); |
| | | |
| | | info( sumcolumn.FinancialWeeklyCell( relsize ), cumulantcolumn.FinancialWeeklyCell( relsize ), proportioncolumn.FinancialWeeklyCell( relsize ) ); |
| | | info( sumcolumn.FinancialWeeklyCell( relsize ), proportioncolumn.FinancialWeeklyCell( relsize ) ); |
| | | *] |
| | | } |