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



      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.