6 Replies Latest reply: Feb 13, 2013 3:52 PM by Gysbert Wassenaar RSS

    Set Analysis two fields not equal

    Frank Velthuis

      I want to sum the sales of the customers not beloning to a that segment last year.

      I'm trying:

           Sum( {$<[SEGMENT 2012]-=[SEGMENT 2013]>} SALES)

      but this is not a correct expression.

       

      Second question: How would the syntax looks like if I hadn't had the SEGMENT spilt up in years:

           Sum( {$<YEAR={2012},[SEGMENT]-=YEAR={2013},[SEGMENT]>} SALES)