total for TOTAL函数计算表达式值总和,返回值及语法介绍

股票杠杆开户:TOTALThe TOTAL function calculates the total of the values of an expression

股票杠杆开户

<炒股杠杆平台>total for TOTAL函数计算表达式值总和,返回值及语法介绍

TOTAL

The TOTAL the total of the of an .

Value

The data type of the . It can betotal for, , or .

TOTAL( )

The to be .

Can be when one or more of the of the of the are not of the . (See the of the .) When you the when this is not the case, OLAP an error.

When one or more of the of the of the are not of the , OLAP a to use while the . When you the , OLAP uses the of the of the for the size of this . In this , the might be in order for OLAP to the , or the might a :

When you use TOTAL with the for an that going of the for (for , with the or or with a data ), the of the will be as NA.

The of the . By , TOTAL a value. When you one or more for the , TOTAL a total for each value of the that are and an array of . Each must be a of or to one of its . When it is a , you can the name of the of the name. This you to which is used when there is more than one.

Notes

NA

TOTAL is by the . When is set to YES (the ), TOTAL NA and the sum of the that are not NA. When is set to NO, TOTAL NA when any value in the is NA. When all data for a are NA, TOTAL NA for of .

to

When you , TOTAL adds the of an array one or more of its to an array with fewer . of this, TOTAL is for data from a lower level of to a level.

over a Time

When is by a of type DAY, WEEK, MONTH, , or YEAR, you can any other DAY, WEEK, MONTH, , or YEAR as a . OLAP uses the the . To the of one DAY, WEEK, MONTH, , or YEAR to (for , from weeks to ), you can an the two and the name of the as the to the TOTAL .

For each time in the , OLAP the data for all the time that end in the time . This is used of which has the more time . To the way in which data is or the of two time , you can use the .

in a TOTAL

When you break out the total by a , you are the of the , so OLAP based on this new . It the that holds of that .

When there is more than one that holds of the , OLAP uses the one that was first. When there is no in which the is the one , OLAP looks for a that is by the .

total for_TOTAL function syntax_TOTAL function return value

For , that there are two and , as .

DEFINE REGION.DISTRICT RELATION REGION 
LD The region each district belongs to
 
DEFINE DISTRICT.REGION RELATION DISTRICT 
LD The primary district in each region

When a had the two and you the , OLAP would use the . by , it holds of the .

REPORT TOTAL(sales region)

23-28 Sales over All

you would like to see the total sales for all for each . Use the TOTAL to the total sales. To see a total for each , as the of the .

LIMIT product TO 'Sportswear'
REPORT W 15 HEADING 'Total Sales' TOTAL(sales district)

The the .

DISTRICT         Total Sales
-------------- ---------------
Boston            1,659,609.90
Atlanta           3,628,616.62
Chicago           2,296,631.81
Dallas            3,893,829.30
Denver            2,133,425.29
Seattle           1,298,215.59

本文的版权归属于[炒股杠杆平台]。未经许可,任何个人或机构不得擅自复制、传播、修改或用于商业用途。本文链接:http://wwww.tyjjkj.com/html/gupiaoganggankaihu/1111.html

二维码
浏览器扫一扫访问

联系管理员

在线咨询:点击这里给我发消息

邮箱:596123666@qq.com