<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.zcubes.com/index.php?action=history&amp;feed=atom&amp;title=Manuals%2Fcalci%2FBOTTOM</id>
	<title>Manuals/calci/BOTTOM - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.zcubes.com/index.php?action=history&amp;feed=atom&amp;title=Manuals%2Fcalci%2FBOTTOM"/>
	<link rel="alternate" type="text/html" href="https://wiki.zcubes.com/index.php?title=Manuals/calci/BOTTOM&amp;action=history"/>
	<updated>2026-04-28T01:08:32Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.35.2</generator>
	<entry>
		<id>https://wiki.zcubes.com/index.php?title=Manuals/calci/BOTTOM&amp;diff=208187&amp;oldid=prev</id>
		<title>Swapna: Created page with &quot;&lt;div style=&quot;font-size:30px&quot;&gt;'''BOTTOM(Array, Count)'''&lt;/div&gt;&lt;br/&gt; *&lt;math&gt;Array&lt;/math&gt; is the set of elements in an array *&lt;math&gt;Count&lt;/math&gt; is the number of bottom elements o...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.zcubes.com/index.php?title=Manuals/calci/BOTTOM&amp;diff=208187&amp;oldid=prev"/>
		<updated>2017-05-13T02:07:30Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;&amp;lt;div style=&amp;quot;font-size:30px&amp;quot;&amp;gt;&amp;#039;&amp;#039;&amp;#039;BOTTOM(Array, Count)&amp;#039;&amp;#039;&amp;#039;&amp;lt;/div&amp;gt;&amp;lt;br/&amp;gt; *&amp;lt;math&amp;gt;Array&amp;lt;/math&amp;gt; is the set of elements in an array *&amp;lt;math&amp;gt;Count&amp;lt;/math&amp;gt; is the number of bottom elements o...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;div style=&amp;quot;font-size:30px&amp;quot;&amp;gt;'''BOTTOM(Array, Count)'''&amp;lt;/div&amp;gt;&amp;lt;br/&amp;gt;&lt;br /&gt;
*&amp;lt;math&amp;gt;Array&amp;lt;/math&amp;gt; is the set of elements in an array&lt;br /&gt;
*&amp;lt;math&amp;gt;Count&amp;lt;/math&amp;gt; is the number of bottom elements of a given array to be displayed &lt;br /&gt;
&lt;br /&gt;
==Description==&lt;br /&gt;
*BOTTOM() function is used to display the mentioned number of bottom values in an array, starting from the end value.&lt;br /&gt;
*The values are displayed in reverse order. i.e bottom value first.&lt;br /&gt;
*Argument &amp;lt;math&amp;gt;Array&amp;lt;/math&amp;gt; can be text, numbers, or any special characters like @,&amp;amp;...&lt;br /&gt;
*&amp;lt;math&amp;gt;Array&amp;lt;/math&amp;gt; should be entered in double quotes(&amp;quot;&amp;quot;) for text and special characters.&lt;br /&gt;
*Argument &amp;lt;math&amp;gt;Count&amp;lt;/math&amp;gt; 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.&lt;br /&gt;
*For &amp;lt;math&amp;gt;Count&amp;lt;/math&amp;gt; greater than number of elements in array, Calci displays null values along with the original array.&lt;br /&gt;
&lt;br /&gt;
==Examples==&lt;br /&gt;
*BOTTOM([1,9,15,34,22,6],2) = 6 22&lt;br /&gt;
*BOTTOM(1..10,5) = 10 9 8 7 6&lt;br /&gt;
*BOTTOM([200,300,400],0.6) = 400&lt;br /&gt;
*BOTTOM([&amp;quot;name&amp;quot;,&amp;quot;address&amp;quot;,&amp;quot;pin&amp;quot;],1/3) = pin&lt;br /&gt;
*BOTTOM(1..5,-2) = Error&lt;br /&gt;
*BOTTOM(1..5,7) = 5 4 3 2 1 null null&lt;br /&gt;
&lt;br /&gt;
==Related Videos==&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|baBgj4GK6bE|280|center|Determining Top and Bottom Values}}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==See Also==&lt;br /&gt;
&lt;br /&gt;
*[[Manuals/calci/BOTTOMN | BOTTOMN]]&lt;br /&gt;
&lt;br /&gt;
*[[Manuals/calci/TOP | TOP]]&lt;br /&gt;
&lt;br /&gt;
*[[Manuals/calci/TOPN | TOPN]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==References==&lt;br /&gt;
&lt;br /&gt;
*[https://en.wikipedia.org/wiki/Array_data_structure Array]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
*[[Z_API_Functions | List of Main Z Functions]]&lt;br /&gt;
&lt;br /&gt;
*[[ Z3 |   Z3 home ]]&lt;/div&gt;</summary>
		<author><name>Swapna</name></author>
	</entry>
</feed>