2 Replies Latest reply: Aug 18, 2016 11:37 AM by Allu Allu RSS

    Expression Issue

    Ben Vozza

      Hi,

       

      I was wondering why the condition in this expression for a measure is not valid?

       

      count({<left(adjmt_id ,2) = '05'>} adjmt_id)

       

      Thanks,

       

      Ben

        • Re: Expression Issue
          m w

          You can use IF:

          count(if(left(adjmt_id ,2) = '05', adjmt_id))

           

          Or you can create a new field in script:

          left(adjmt_id ,2) as NewField;


          Then:

          count({<NewField = {'05'}>} adjmt_id)

          • Re: Expression Issue
            Allu Allu

            I think you can NOT Evaluate or do functions ON THE LEFTSIDE of Modifiers ...

             

            But anyway

             

            check with this

             

             

            count({<left(adjmt_id ,2) = {"05"}>} adjmt_id)

             

             

             

            or

             

            count({<adjmt_id={"=left(adjmt_id,2)=05"}> adjmt_id)