1 of 1 people found this helpful
Use a custom if-then-else calculation for the boolean expression.
Something like this:
If <boolean Expression> then "positive" else "negative" end. E.g: If (AVG([Profit])>=0) then "Positive" else "Negative" END
Sorry, In my response, for whatever reason I assumed you had an inline calculation (as in the calculation was in the pill itself). If you have saved the calculation as a dimension, you should be able to just change the alias name. To do that you right click on the dimension pill and choose "Aliases...". This obviously is a lot simpler than rewriting the calc as shown above! Both are correct approaches, but one is a lot simpler than the other