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!