13 Replies Latest reply: Jan 2, 2016 8:00 AM by Hirish V RSS

    need to add this expression to a text box.

    Jim Chan

      Hi guys,

       

      i am looking for alternative object, instead of using Straight table, for some reason, i wanted to use textbox instead.

       

      this is the expression that i used in a straight box:

       

      =if(RC_COUNTRYNAME='India',if (RC_TITLE='Executive Summary',if(RC_KPI='Overall',IF(len(RC_RGNL_CMNTS)=0 AND len(RC_CNTRY_CMNTS)=0,'NO COMMENTS AVAIL',IF(len(RC_RGNL_CMNTS)=0 ,RC_CNTRY_CMNTS,RC_RGNL_CMNTS)))))

       

      seems that i cant directly copy this and use it in a text box.

      error.png

       

      Rgds.

       

      Jim