Former Member

# Conditional Formula

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.

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Nov 30, 2005 at 11:55 PM

If you work for one of those companies who do not encourage VB code in workbooks. You could achieve the same in two ways:

1. Have another cube/ODS with the extra characteristics (for good and bad) on top of the existing infoprovider. Use an update rule validating and populating the new characteristics with good and bad. And move the exiting query on to the new cube. You could run the update to the new cube/ODS on a quarterly basis as a scheduled job. And this may also speed up your query performance.

2. Secondly, you could also use APD (Application Process Designer) to do the transformation from the current infoprovider to the new cube/ODS.

Hope this helps.

-RJ

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 30, 2005 at 06:52 PM

Hi..

I am not too sure about a variable that will display alphanumeric values..But you could use the Exceptions where you can define a Colour for different value ranges..

Hope it helps

Ashish.

10|10000 characters needed characters exceeded
• Former Member Former Member

Just another Idea..

You could evaluate the condition for Good or bad in terms of Boolean Expression.( 1 & 0 ) and then try to write a VBA code in a workbook to populate the Alphanumeric value depending upon the value of the cell..

Good Luck..

Ashish..