DMIN

Returns the minimum value from selected database entries.


Database

/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DMIN.php:64:
array (size=7)
  4 => 
    array (size=5)
      'A' => string 'Tree' (length=4)
      'B' => string 'Height' (length=6)
      'C' => string 'Age' (length=3)
      'D' => string 'Yield' (length=5)
      'E' => string 'Profit' (length=6)
  5 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 18
      'C' => float 20
      'D' => float 14
      'E' => float 105
  6 => 
    array (size=5)
      'A' => string 'Pear' (length=4)
      'B' => float 12
      'C' => float 12
      'D' => float 10
      'E' => float 96
  7 => 
    array (size=5)
      'A' => string 'Cherry' (length=6)
      'B' => float 13
      'C' => float 14
      'D' => float 9
      'E' => float 105
  8 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 14
      'C' => float 15
      'D' => float 10
      'E' => float 75
  9 => 
    array (size=5)
      'A' => string 'Pear' (length=4)
      'B' => float 9
      'C' => float 8
      'D' => float 8
      'E' => float 76.8
  10 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 8
      'C' => float 9
      'D' => float 6
      'E' => float 45

Criteria

ALL

The shortest tree in the orchard
DMIN() Result is 0

Criteria

/var/www/html/onswitch.neon.service/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DMIN.php:81:
array (size=2)
  1 => 
    array (size=1)
      'A' => string 'Tree' (length=4)
  2 => 
    array (size=1)
      'A' => string '=Apple' (length=6)
The Youngest apple tree in the orchard
DMIN() Result is 9