5 Replies Latest reply on Nov 30, 2016 6:02 AM by Ashish Chaudhari

    upper , lower calculation is working differently

    Clay water

      HI,

       

        my calculation is

       

        IF [Market]='Africa' THEN UPPER(left([Country],3))

      ELSE LOWER(right([Country],3))

      END

      but the output is crazy .. look at the below jpg file

      Capital letters are displaying.JPG

       

      Can someone help me plzzzz