Formatting colour in Webi XIr2

building reports webintelligence
1

Hi all,

In the Webi “Index to Date and Number Formats”, there is a section called “Formatting cells displaying number and currency data”, which includes details of how you can format colours by using special characters. E.g. “##,##0[Blue]” will show the specified value in blue.

HOWEVER, it looks like the FormatNumber() and FormatDate() functions are both incompatible with this option.

What function can we use to format colour in Webi (using the above-mentioned special characters)?

Any insight would be much appreciated.
Thanks in advance~

leesy (BOB member since 2008-04-02)

2

As far as I know, we are not having any such function for formatting color. Instead we have to opt for Alerters or the normal formats.

Jansi :india: (BOB member since 2008-05-12)

3

Hi Jansi,

Thanks for your reply.
One more question - is there a way to apply alerters on line graphs?

Kind regards,

leesy (BOB member since 2008-04-02)

4

Please Check the Dave’s Site , there is a separate section created on " how to create alerters on charts.

Thanks
Aniket

aniketp :uk: (BOB member since 2007-10-05)

5

Hi Aniket,

Could you please provide a link to this site?
Thanks in advance~

Kind regards,

leesy (BOB member since 2008-04-02)

6

Check Dave’s adventures here

Jansi :india: (BOB member since 2008-05-12)

7

Thanks Jansi. Much appreciated.

Kind regards,

leesy (BOB member since 2008-04-02)