ConsolidationFunction

Inheritance: java.lang.Object

public final class ConsolidationFunction

Represents consolidation function.

Fields

FieldDescription
AVERAGERepresents Average function.
COUNTRepresents Count function.
COUNT_NUMSRepresents Count Nums function.
DISTINCT_COUNTRepresents Distinct Count function.
MAXRepresents Max function.
MINRepresents Min function.
PRODUCTRepresents Product function.
STD_DEVRepresents StdDev function.
STD_DEVPRepresents StdDevp function.
SUMRepresents Sum function.
VARRepresents Var function.
VARPRepresents Varp function.

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

AVERAGE

public static final int AVERAGE

Represents Average function.

COUNT

public static final int COUNT

Represents Count function.

COUNT_NUMS

public static final int COUNT_NUMS

Represents Count Nums function.

DISTINCT_COUNT

public static final int DISTINCT_COUNT

Represents Distinct Count function.

Remarks

Only valid for PivotTable with Data Module created since by 2013.

MAX

public static final int MAX

Represents Max function.

MIN

public static final int MIN

Represents Min function.

PRODUCT

public static final int PRODUCT

Represents Product function.

STD_DEV

public static final int STD_DEV

Represents StdDev function.

STD_DEVP

public static final int STD_DEVP

Represents StdDevp function.

SUM

public static final int SUM

Represents Sum function.

VAR

public static final int VAR

Represents Var function.

VARP

public static final int VARP

Represents Varp function.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int