8 Replies Latest reply: Jun 14, 2018 6:44 AM by omar bensalem RSS

    text and case sensitive

    Del Booth

      Hi.

       

      I would like to sum a field Quantity_ Collected from the field Account_Name which can have the text 00012 PAUL or 00012 paul so it gives me a sum for Paul ignoring the fact some are in upper and some lowercase.

       

      Thanks

      Del