NumericCount  chart function
Syntax:
NumericCount([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)
Return data type: integer
Arguments:
Argument  Description 

expr  The expression or field containing the data to be measured. 
SetExpression  By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a set analysis expression. 
DISTINCT  If the word DISTINCT occurs before the function arguments, duplicates resulting from the evaluation of the function arguments are disregarded. 
TOTAL 
If the word TOTAL occurs before the function arguments, the calculation is made over all possible values given the current selections, and not just those that pertain to the current dimensional value, that is, it disregards the chart dimensions. The TOTAL qualifier may be followed by a list of one or more field names within
angle brackets 
Examples and results:
Customer  Product  OrderNumber  UnitSales  Unit Price 

Astrida  AA  1  4  16 
Astrida  AA  7  10  15 
Astrida  BB  4  9  1 
Betacab  BB  6  5  10 
Betacab  CC  5  2  20 
Betacab  DD  25  
Canutility  AA  15  
Canutility  CC  19  
Divadip  AA  2  4  16 
Divadip  DD  3  25 
The following examples assume that all customers are selected, except where stated.
Example  Result 


7 because three of the 10 fields in Note: "0" counts as a value and not an empty cell. However if a measure aggregates to 0 for a dimension that dimension will not be included in charts.


0 because all product names are in text. Typically you could use this to check that no text fields have been given numeric content. 

Counts all the number of distinct numeric order numbers and divides it by the number of order numbers numeric and nonnumeric. This will be 1 if all field values are numeric. Typically you could use this to check that all field values are numeric. In the example, there are 7 distinct numeric values for 
Data used in example:
Temp:
LOAD * inline [
CustomerProductOrderNumberUnitSalesUnitPrice
AstridaAA1416
AstridaAA71015
AstridaBB499
BetacabCC6510
BetacabAA5220
BetacabBB 25
CanutilityAA15
CanutilityCC 19
DivadipCC2416
DivadipDD3125
] (delimiter is '');