Conditional formatting rule for Ikon and measure value

[former_member555797]

cfcapture.png

Hi Gurus,

I have 6 measures in a webi report and I would like to use a conditional formatting comparison for example : downward trend symbol (=Char(9660)) + measure value in red text (-4 %)

Is there any possible way to combine trend symbol and measure value in one conditional format rule ?

Currently either i can use same measure for two purposes, one for trend and another one as values.

Regards,

Nitin

[sven_oehme]

Hi Nitin,

I'am not sure if I understood you correctly. You just want to combine the measure and your trend symbol in one column?

Just put a formula like this into: [measure] + (If([measure] <= 0) Then Char(9660) Else Char(9650))

Then put a conditional format with two functions for green an red on it.

Greetz

Sven

[former_member555797]

Hi Sven,

Thanks for your reply. I will try to explain in a simple way. I am using only bex query to build a report in Webi. Bex query contains structure and KF's. Out of the report I need to show some of the cells empty due to business reasons. In order to get this result I build this formula in a variable, The measure [diff retail marge] is a number in webi but as soon as i apply this formula it becomes string :

=If([Query 1].[Struct.]="Optiek (glas+monturen)"; "";If([Query 1].[Struct.]="Glas";"";If([Query 1].[Struct.]="Enkelvoudig";"";If([Query 1].[Struct.]="Multifocaal";"";If([Query 1].[Struct.]="Totaal";"";ToNumber([Diff Retail Marge]))))))

So the conditional formatting mentioned by you above doesn't work as the data type becomes invalid. Do you know how we can build the above formula keeping number instead of string ?

Sample data I have attached in a screen shot

Regards,

Nitin

capturestrc.png

[sven_oehme]

Hi Nitin,

I think, the it is a little bit to complicated. Why do you use that space (""). That is the reason for your alphanumeric result. Use instead 0 and expand your conditional format to change that values in a color like the background.

That is not fancy but mybe it is a possibilty for u?

Greetz

Sven

[former_member555797]

Thanks and this is a good clue. I sorted this out.