Skip to Content
avatar image
Former Member

Red color and brackets for negative values

Dear All,

In our Webi report, we want negative numbers to be displayed in red color, with brackets, e.g. (-3.1).

I tried to use alerter for this, but it doesn't seem to work

Any other way we can achieve this?

Your guidance and help would be appreciated.

Regards,

Prerna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Apr 29, 2013 at 06:14 AM

    Hi,

    If you are in BI 4.0 choose column where you want to apply rule then goto  new rule, choose format. In display write if condition on your KPI, as shown below.

    Choose color as red, the outcome will be negative values in bracket i.e. (-10)

    if you are on 3.x than i guess alerts should have the similar option.

    regards,

    ray

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Prerna,

      Try converting it to number in formula and then use the similar condition. It work perfectly fine in my case and you might has small syntax error that can be resolved.

      Try something like this =If(ToNumber([No of PO Count])<=10) Then ("(-"+[No of PO Count]+")")

      regards,

      ray

  • avatar image
    Former Member
    Apr 29, 2013 at 06:15 AM

    Hi Prerna,

    Right Click on the required cell and Select "Format Number" option.

    Then select the option listed in the screenshot as below and click on Custom

    Then a new window will be popped up where you have to give your customized formatting options. In the "Negative Cell" give the value as [Red](-0) as in the below screenshot and Click on Add

    This will give you the required Red color and brackets for negative values.

    Note: If you do not want negative sign, you can remove that sign in the Negative box.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 29, 2013 at 07:11 AM

    Hi,

    1. If your Object is a Dimension (which is in String Format), then Convert it into a measure by Creating a Variable with Formula =ToNumber([Year]). Now you can apply Conditional Formatting.

    2. If your object is used in Header of the Table(Either Row Header/Column Header), Place this Variable with the Dimension in the Header(Dimension at First Level and Variable at Second Level) and Hide the Dimension(only variable is visible in the Block).

    Hence, you can Apply Conditional Formatting (Custom Format).

    Hope it helps!!! 😀

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 29, 2013 at 03:39 PM

    This can be achieved with an alerter. However color and bracket signs must be assigned in different sections of your alerter.

    Red color:

    Create a variable (with the the name negative? for example) which evaluates the first character of your string. This can be done with for example substr function. The formula would be similar to the following:

    =If(Substr([Incoming Orders EUR].[Incoming Orders EUR Formatted Value];1;1) = "-";"negative";"")

    Based on the value of this variable you can create an Alerter

    negative? = negative

    and apply red color in the text section

    In brackets:

    In the same Alerter specify that you want a concatenation of bracket signs and your measure object. Please enter something like in the display section of your alerter:

    ="(" + [Incoming Orders EUR].[Incoming Orders EUR Formatted Value]+ ")"

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2013 at 12:40 PM

    Dear all,

    Thank you for your replies.

    Issue sorted. 😊

    Really appreciate your help.

    Awarded points. 😊

    Regards,

    Prerna

    Add comment
    10|10000 characters needed characters exceeded