asposecells.api

asposecells.api

Class ConsolidationFunction

Utility class containing constants. Represents consolidation function.

Field Summary
const  intSUM
Represents Sum function.
const  intCOUNT
Represents Count function.
const  intAVERAGE
Represents Average function.
const  intMAX
Represents Max function.
const  intMIN
Represents Min function.
const  intPRODUCT
Represents Product function.
const  intCOUNT_NUMS
Represents Count Nums function.
const  intSTD_DEV
Represents StdDev function.
const  intSTD_DEVP
Represents StdDevp function.
const  intVAR
Represents Var function.
const  intVARP
Represents Varp function.
const  intDISTINCT_COUNT
Represents Distinct Count function.
 

    • Field Detail

      • SUM

        const int SUM
        Represents Sum function.

      • COUNT

        const int COUNT
        Represents Count function.

      • AVERAGE

        const int AVERAGE
        Represents Average function.

      • MAX

        const int MAX
        Represents Max function.

      • MIN

        const int MIN
        Represents Min function.

      • PRODUCT

        const int PRODUCT
        Represents Product function.

      • COUNT_NUMS

        const int COUNT_NUMS
        Represents Count Nums function.

      • STD_DEV

        const int STD_DEV
        Represents StdDev function.

      • STD_DEVP

        const int STD_DEVP
        Represents StdDevp function.

      • VAR

        const int VAR
        Represents Var function.

      • VARP

        const int VARP
        Represents Varp function.

      • DISTINCT_COUNT

        const int DISTINCT_COUNT
        Represents Distinct Count function. Only valid for PivotTable with Data Module created since by 2013.