Skip to Content
author's profile photo Former Member
Former Member

Conditional formatting with WAD

Hi

We have a requirement to create a web report where we would need to:

  • add conditional formatting based on result - compare two fields and set color based on result. e.g. if actual is better than target, the cell containing the actual must be made green

  • add image based on result - compare two further fields (YTD act and target) and add an up arrow if the result is + and down arrow if -.

The result of these fields can be set in BEx using a formula, however, how do you format and call an image within a cell of a table based on the value in the cell?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 31, 2008 at 12:37 PM

    Your first requirement could be achieved creating exception in teh query itself.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 31, 2008 at 01:28 PM

    Follow the steps to create the exception

    First in your query create a Formula using a Boolean Operation.

    (Actual > Target)

    Since this is boolean, if this condition is satisfied it will always populate 1.

    Now goto the Exception for the Key fig select your created formula

    Click on New

    Select the From Value and To Value as 1 and Alert level as Green

    Transfer.

    Save the query and execute

    Your second requirement sounds a bit complex. If you are using WAD 3.5 then this could be achieved using Table Interface by creating a class in SE24 and dynamically populating the cells with the image.

    Edited by: Rakesh Pattani on Jan 31, 2008 2:43 PM

    Add a comment
    10|10000 characters needed characters exceeded

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.