Manuals/calci/BOTTOM

From ZCubes Wiki
Jump to navigation Jump to search
BOTTOM(Array, Count)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of elements in an array
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Count} is the number of bottom elements of a given array to be displayed

Description

  • BOTTOM() function is used to display the mentioned number of bottom values in an array, starting from the end value.
  • The values are displayed in reverse order. i.e bottom value first.
  • Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} can be text, numbers, or any special characters like @,&...
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} should be entered in double quotes("") for text and special characters.
  • Argument should be a positive number less than or equal to the number of values in array. Count with decimal value is rounded to nearest integer.
  • For Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Count} greater than number of elements in array, Calci displays null values along with the original array.

Examples

  • BOTTOM([1,9,15,34,22,6],2) = 6 22
  • BOTTOM(1..10,5) = 10 9 8 7 6
  • BOTTOM([200,300,400],0.6) = 400
  • BOTTOM(["name","address","pin"],1/3) = pin
  • BOTTOM(1..5,-2) = Error
  • BOTTOM(1..5,7) = 5 4 3 2 1 null null

Related Videos

Determining Top and Bottom Values


See Also


References