Navigation:  Formula Reference > ApplyBI Formula Functions >

QAGGRDATA

Previous pageReturn to chapter overviewNext page

 

This function returns the aggregated value of a measure.

Syntax

QAGGRDATA("Expression","Aggregation Type","Default Value",

               "Dimension 1 Filter Name","Dimension 1 Filter Value",

               "Dimension n Filter Name","Dimension n Filter Value" )

Arguments

This function has these arguments:

Argument

Description

Expression

The name of dimension or measure containing the data to be aggregated

Aggregation Type

SUM or COUNT

Default Value

The returned value if the function result is null.

Dimension 1-n Filter Name

The dimension(s) based on which the expression will be evaluated

Dimension 1-n Filter Value

The value of the dimension(s) based on which the expression will be evaluated

 

Data Types

The "Dimension Name" argument accepts dimension or measure values from the drop down menu.

The "Aggregation Type" argument accepts values from the drop down menu(SUM or COUNT).

The "Default Value" argument accepts alphanumeric values.

The "Dimension 1-n Filter Name" argument accepts accepts dimension or measure values from the drop down menu

The "Dimension 1-n Filter Value" argument accepts cell name values(you can use the + button after clicking on a specific cell)..

 

Returns same data type as "Expression" type.

 

Examples

QAGGRDATA("sum([Sales])","SUM","0"). This example will return the total sales.If the result is null then the returned value is 0.

QAGGRDATA("sum([Sales]","SUM","0","Customer","B3"). This example will return the total sales for the customer being on the Cell B3. If the result is null then the returned value is 0.

 

See Also

QGETDATA