14 Replies Latest reply: Oct 16, 2014 5:55 AM by Ashfaq Mohammed RSS

    Set Expression help

    Ananth Reddy

      Hello QV,

       

      I have below expr in my chart.

       

      sum({<Segment={'Group'}, Status = {'Cancelled'}>}[REV YTD])/1000000

      Now my requirement is to exclude Cancelled Accounts, means Status is not equals to 'Cancelled'.

      How to write the expr for the same.

       

      Thanks,

      Ananth