https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92481#M23861 <P>You could also include it in the stats command directly: </P> <PRE><CODE>stats count(eval(Location==" " OR isnull(Location)) </CODE></PRE> Wed, 17 Oct 2012 06:46:47 GMT Ayn 2012-10-17T06:46:47Z https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92479#M23859 <P>Can I use like this : </P> <P>| eval a=if(Location!=" ",stat count by Location)</P> <P>but I am getting error..</P> <P>actually I want to find..I want to get the count for those records which are non-blank</P> <P>Please help</P> Tue, 16 Oct 2012 19:51:21 GMT https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92479#M23859 abhayneilam 2012-10-16T19:51:21Z https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92480#M23860 <P>I am not sure that you can use conditional searches, just conditional field calculation using eval.</P> <P>another way is to make sure that the field location exits, then count<BR /> <CODE>| WHERE NOT ( Location=" " OR isnull(Location) ) | stat count by Location</CODE></P> Wed, 17 Oct 2012 02:57:01 GMT https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92480#M23860 yannK 2012-10-17T02:57:01Z https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92481#M23861 <P>You could also include it in the stats command directly: </P> <PRE><CODE>stats count(eval(Location==" " OR isnull(Location)) </CODE></PRE> Wed, 17 Oct 2012 06:46:47 GMT https://community.splunk.com/t5/Splunk-Search/if-else-condition/m-p/92481#M23861 Ayn 2012-10-17T06:46:47Z