3 Replies Latest reply: Jan 8, 2018 4:53 PM by Ashley Kuttler RSS

    Set modifier with relational operator Not equal to 0

    Ashley Kuttler

      Hello,

       

      I have a variable for 2017 transactions:

       

      Sum({<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans<>{0} >}Trans)

       

      I am trying to exclude transactions that equal "0.00" but it gives me an error in the expression.

       

      Thanks in advance.