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

    upper , lower calculation is working differently

    Clay water



        my calculation is


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

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


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

      Capital letters are displaying.JPG


      Can someone help me plzzzz