Skip to Content
author's profile photo Former Member
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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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.

    Add a comment
    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..

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.