I need to accomplish the following:
I need to create a formula that says if it was a good or bad quarter: If number of products sold was less than x i need to display the value "bad" in the respective column otherwise display "good".
Using the IF-THEN-ELSE logic of BW the statement should be more or less like this:
(number is products>x)(formula variable that displays the word "good")+ not((number is products>x))formula variable that displays the word "bad")
My problem is that i don't really understand how to create a formula variable that shows an alphanumeric value.