Class DCount

  • All Implemented Interfaces:
    IDStarAlgorithm

    public final class DCount
    extends Object
    implements IDStarAlgorithm
    Implementation of the DCount function: Counts the number of numeric cells in a column in an area with given conditions.
    • Constructor Detail

      • DCount

        public DCount()
    • Method Detail

      • processMatch

        public boolean processMatch​(ValueEval eval)
        Description copied from interface: IDStarAlgorithm
        Process a match that is found during a run through a database.
        Specified by:
        processMatch in interface IDStarAlgorithm
        Parameters:
        eval - ValueEval of the cell in the matching row. References will already be resolved.
        Returns:
        Whether we should continue iterating through the database.
      • getResult

        public ValueEval getResult()
        Description copied from interface: IDStarAlgorithm
        Return a result ValueEval that will be the result of the calculation. This is always called at the end of a run through the database.
        Specified by:
        getResult in interface IDStarAlgorithm
        Returns:
        a ValueEval
      • allowEmptyMatchField

        public boolean allowEmptyMatchField()
        Description copied from interface: IDStarAlgorithm
        Whether the field value (the 2nd param in DCOUNT, DGET, etc.) can evaluate to empty. It is allowed to evaluate to empty for DCOUNT.
        Specified by:
        allowEmptyMatchField in interface IDStarAlgorithm
        Returns:
        whether the field value can evaluate to empty