16 Replies Latest reply: Mar 17, 2017 11:01 AM by Stefan Wühl RSS

    Using Variable Like A Regular Field

    Matt Maino

      Hello,

       

      Is it possible to use a variable in the same way that you'd use a field in an expression. I basically need to calculate a total in a text box that counts the number of records that have a specific variable value, but this can't be a field that I create in my script because it is based on the current selection - it can't be static. This is what I have in my text box expression and it's not working:

       

      count(distinct if($(c_status) = -1, [Customer Number]))

       

      Is there anything I could do to make this work?

       

      Thanks!