crosstabsum函数的用法？解决办法
crosstabsum函数的用法？
crosstabsum函数的用法？最好给出例子，谢谢各位
------解决方案--------------------
看help
------解决方案--------------------
Description
Calculates the sum of the values returned by an expression in the values list of the crosstab. When the crosstab definition has more than one column, CrosstabSum can also calculate the sum of the expression's values for groups of column values.
For crosstabs only You can use this function only in a crosstab DataWindow object or report.
Syntax
CrosstabSum ( n {, column, groupvalue } )
Argument Description
n The number of the crosstab-values expression for which you want the sum of the returned values. The expression's data type must be numeric.
column (optional) The number of the crosstab column as it is listed in the Columns box of the Crosstab Definition dialog box for which you want intermediate calculations.
groupvalue (optional) A string whose value controls the grouping for the calculation. Groupvalue is usually a value from another column in the crosstab. To specify the current column value in a dynamic crosstab, rather than a specific value, specify @ plus the column name as a quoted string.
Return value
Double. Returns the total of the values returned by expression n for all the column values or, optionally, for a subset of column values.
Usage
This function is meaningful only for the sum of the values of the expression in a row in the crosstab. This means you can use it only in the detail band, not in a header, trailer, or summary band.
NULL values are ignored and are not included in the sum.
For more information about restricting the calculation to groups of values when the crosstab definition has more than one column, see Usage for CrosstabAvg.
Reviewing the expressions To review the expressions defined for the crosstab values, open the Crosstab Definition dialog box (select Design>Crosstab from the menubar).
------解决方案--------------------
功能 计算交叉表指定表达式的合计
语法 CrosstabSum ( n {, column, groupvalue } )
参数 n 交叉表表达式编号 指定要计算哪个表达式定义数据的合计
column 可选项 交叉表列号 这里的列是 Crosstab Definition 对话框中Columns 框中定义的列
groupvalue 可选项 String类型 指定分组方式 通常使用交叉表中另一列的值如果要在动态交叉表中引用指定列的当前值 那么该参数中在列名前放上
@ 符号 例如"@year"
返回值 Double 返回第 n 个表达式指定范围计算数据的合计
crosstabsum函数的用法？最好给出例子，谢谢各位
------解决方案--------------------
看help
------解决方案--------------------
Description
Calculates the sum of the values returned by an expression in the values list of the crosstab. When the crosstab definition has more than one column, CrosstabSum can also calculate the sum of the expression's values for groups of column values.
For crosstabs only You can use this function only in a crosstab DataWindow object or report.
Syntax
CrosstabSum ( n {, column, groupvalue } )
Argument Description
n The number of the crosstab-values expression for which you want the sum of the returned values. The expression's data type must be numeric.
column (optional) The number of the crosstab column as it is listed in the Columns box of the Crosstab Definition dialog box for which you want intermediate calculations.
groupvalue (optional) A string whose value controls the grouping for the calculation. Groupvalue is usually a value from another column in the crosstab. To specify the current column value in a dynamic crosstab, rather than a specific value, specify @ plus the column name as a quoted string.
Return value
Double. Returns the total of the values returned by expression n for all the column values or, optionally, for a subset of column values.
Usage
This function is meaningful only for the sum of the values of the expression in a row in the crosstab. This means you can use it only in the detail band, not in a header, trailer, or summary band.
NULL values are ignored and are not included in the sum.
For more information about restricting the calculation to groups of values when the crosstab definition has more than one column, see Usage for CrosstabAvg.
Reviewing the expressions To review the expressions defined for the crosstab values, open the Crosstab Definition dialog box (select Design>Crosstab from the menubar).
------解决方案--------------------
功能 计算交叉表指定表达式的合计
语法 CrosstabSum ( n {, column, groupvalue } )
参数 n 交叉表表达式编号 指定要计算哪个表达式定义数据的合计
column 可选项 交叉表列号 这里的列是 Crosstab Definition 对话框中Columns 框中定义的列
groupvalue 可选项 String类型 指定分组方式 通常使用交叉表中另一列的值如果要在动态交叉表中引用指定列的当前值 那么该参数中在列名前放上
@ 符号 例如"@year"
返回值 Double 返回第 n 个表达式指定范围计算数据的合计