Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
Shoot not working on the including piece. I can keep playing with it. It is just displaying as if it is not included so far.
How about this
If(GetFieldSelection([Business Segment]) = 'Nuts', Sum({<[Product Line] = {'Apples'}, [Business Segment]>}[capital]) + Sum(capital), Sum(capital))
I will try this out when I get a chance. As always, thank you so much for your help Sunny.
No problem at all