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

    Set Expression help

      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.