https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210391#M61509 <P>You can use the eval command to create a new columns or modify the values of the current columns (documentation here: <A href="http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/eval" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/eval</A>)</P> <P>Renaming your columns will make the eval strings a bit neater, for example.. </P> <P>... | rename "count(CMDB Server" as "CMDB_Server", "count(CMDB APP)" as "CMDB_App" | eval CMDB_App = CMDB_App/CMDB_Server</P> Tue, 29 Sep 2020 07:47:17 GMT jluo_splunk 2020-09-29T07:47:17Z https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210390#M61508 <P>How would I divide each value in this row by the count(CMDB SERVER) calc?<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/779i79F840212CE56C5E/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Fri, 30 Oct 2015 17:22:53 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210390#M61508 jhayIV 2015-10-30T17:22:53Z https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210391#M61509 <P>You can use the eval command to create a new columns or modify the values of the current columns (documentation here: <A href="http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/eval" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/eval</A>)</P> <P>Renaming your columns will make the eval strings a bit neater, for example.. </P> <P>... | rename "count(CMDB Server" as "CMDB_Server", "count(CMDB APP)" as "CMDB_App" | eval CMDB_App = CMDB_App/CMDB_Server</P> Tue, 29 Sep 2020 07:47:17 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210391#M61509 jluo_splunk 2020-09-29T07:47:17Z https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210392#M61510 <P>Assuming the columns are dynamic you'll want to use <CODE>foreach</CODE>:</P> <PRE><CODE>... | rename "count(CMDB SERVER)" as cmdb | foreach count* [eval &lt;&lt;FIELD&gt;&gt; = '&lt;&lt;FIELD&gt;&gt;' / cmdb] | rename cmdb as "count(CMDB SERVER)" </CODE></PRE> Sun, 01 Nov 2015 00:23:53 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-divide-each-value-in-this-row-by-a-value-in-one-of-the/m-p/210392#M61510 martin_mueller 2015-11-01T00:23:53Z