0 Replies Latest reply: Jul 9, 2012 7:36 AM by Coen Busker RSS

    Expression problem (sum if replace)

      Hi, can anaone help me with this problem? For this sample I simplified the expression.

      In a text object I need to replace some text like this:


      =sum(if(replace('str1_dim1 > 100', 'str1', 'val1'), budget))

      Q: what is wrong about this? How can I force the string-replacement?



      Original this would be something like:

      vTmp = 'str1_dim1 > 100'

      =sum(if(replace($(vTmp), 'str1', 'val1'), budget))