6 Replies Latest reply: Feb 19, 2015 10:18 AM by Paul Gelardi RSS

    Trying to select null values in set analysis

    Paul Gelardi

      I looked throughout the community and I can't seem to figure out why my expression isn't working for selecting values that are null.

       

      The expression works fine without the one piece I added (which is the STORE_CONV_FROM-={'*'}, part).

       

      I know that the dimension called STORE_CONV_FROM only contains numbers for certain stores who were previously open as a different store and I do NOT want to select them.

       

      sum({$<LinkPeriod={0},
      CalendarType={'Fiscal'},
      WeekType={'Retail'},
      Year={$(=max(Total Year))},
      StoreStatus={'New'},
      StoreRefOpenDate={'>=4/27/2014'},
      %Date={'<=$(=date(CurrentDate))'},
      STORE_CONV_FROM-={'*'},
      CompleteWeekFlag
      >}
      NET_SALES)