2 Replies Latest reply: Apr 6, 2017 8:29 AM by Carlos Sanchez RSS

    Dynamic Operand within an expression

    Carlos Sanchez

      Hi All,


      I want to uses this expression if(sum(Sales) =$(vCondtion) $(vGoal), 1,0), to dynamically to use the variable condition (vCondtion) it currently return a NULL value.


      The idea it's to set a variable with the content of a field (Operand), this field contain a arithmetic operand (<=,>=, =), and then do a comparison between Sales and Goal. Goal is a input variable.


      I'm attaching a document.


      If this possible to do or there is another way to do it.


      Thanks in advance any help!