4 Replies Latest reply: May 16, 2012 9:53 AM by jonraine RSS

    Not Equal To in Chart Sheet Object

      Hi,

       

      Apologies - I have read the various posts on "Not Equal To" but have still failed to get my expression working on a Chart Sheet Object.

       

      The expression I am seeking to fix:

       

      =COUNT({<

      STATUS={'Completed','Checked'},

      TASK_TYPE={'Build'},

      TASK_REF NOT EQUAL TO {'TR0123456789','TR9876543210'}

      >}TASK_REF)

       

       

      Please could someone suggest the operator / syntax that I could use...

       

      Many thanks,

       

      Jonathan

        • Re: Not Equal To in Chart Sheet Object
          Stefan Wühl

          Right, I believe this is one of the questions that appear repeatingly here.

           

          Try

           

          =COUNT({<

          STATUS={'Completed','Checked'},

          TASK_TYPE={'Build'},

          TASK_REF -= {'TR0123456789','TR9876543210'}

          >}TASK_REF)

           

           

          Edit:

          A common mistake is to look at the equal sign in above set expression as a comparison operator. You don't compare field STATUS to values Completed or checked, you create a set (like a selection set, so it's more a set assignment than a comparison).

          In a similar way, if you want to create a set that does not contain value, you remove them from your current selection using -= (minus equal) the short form for TASK_REF = TASK_REF - {'TR0123456789'}

           

          Hope this helps,

          Stefan