13 Replies Latest reply: Jan 9, 2018 5:27 PM by Sunny Talwar RSS

    Exclude a product line from measure equation

    Russell Glenn

      Hello and Happy New Year!!!

       

      I am attempting to exclude a certain product line in a capital KPI chart.

       

      The measure is: sum([capital])

       

      So I attempted with this formula.

       

      If([Business Segment]='Fruits', not Match([Product Line],
      'Grapes'), [Product Line]

       

      and

       

      sum([Capital]))

       

      What I am trying to do is say, when I am selected on Fruits, I want to exclude grapes (is a product line) from the KPI capital number.

      Currently, I am getting a dash with the above equation.

       

      Thanks in advance for your help!!!!