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]






      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!!!!