Skip to Content
0
Former Member
Nov 30, 2005 at 06:50 PM

Conditional Formula

64 Views

Hi,

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.

Any ideas??

Thanks.