14 Replies Latest reply: Sep 28, 2017 8:20 AM by Sunny Talwar RSS

    Function in If

    Mukesh Baba Kodeboina

      Hi all,

       

      I have a small problem in the aggregation function  that is if I am using the below query I am not able to get the answer

       

      count({< $(=upper(column1))={'SAMPLE'}>}   result)

      The column1 has values in different cases(sample,Sample,SAMPLE,SAMple).In each and every case I require the result.

      I know that I can use comma seperator as  count({< column1={'SAMPLE','sample','Sample','SAMple'}>}   result)

      to achieve the result but there  may be n cases. Is there any direct method to achieve this.

       

      can u guys help to solve the problem.

       

      regards,

      mukesh..