12 Replies Latest reply: Feb 8, 2017 4:05 AM by Mike Slottje RSS

    Exclude with IF in SUM expression Set-Analysis

    Mike Slottje

      Hi All,

       

      let's assume I have the following categories and the measure Nett Amount:

       

      Category

      Subcategory

      A1
      2
      3
      B
      C
      D

       

      As measure, I want to use the SUM of sales of all the categories: SUM([Nett Amount])

      To get an accurate overview of the sales, I want the SUM Nett Amount of all the categories without subcategory A2.

      So there is one field that has to be excluded.

       

      I tried such an expression like: SUM((IF(Not match(Subcategory,2)Subcategory))[Nett Amount]), but that didn't work.

      How do I write such an expression?


      Thanks a lot!

      Mike