Case sensitivity




In one of my project i need to check whether the opportunity name already been used or not with Boolean but Anaplan is not considering the case sensitivity. For Ex: if the opportunity name in Apple and user comes in and input apple(with no capital A) Anaplan is recording it as a unique name. Ideally it should flag for the duplication.


I user UPPER and LOWER for all the opportunity but for the opportunity with 2 words make lot of combination which is hard to consider.

Let me know if there is any solution.

Best Answer

  • anand.shekhawat



    Convert both the texts that you want to compare either in lower case or uppercase, and then you can compare the same. Follow the below snip.