Alert dose not Work whan Including Sum in the Formula

[Former Member]

Hello all,

I am working on below table in Webi.

And I need to show the Green/ Red alert Images based on the "%" value in the last column comparing to the "total %"

as follow:

Red: "=[Sales_%] < Sum([Sales_%])"

Green : "=[Sales_% > Sum([Sales_%])]"

I am using the Conditional Format. When I try the above formulas comparing to a number as below, It works fine. However, when I replace the numbers with "Sum([Sales_%])", the images are not showed.

Red: "=[Sales_%] < 100"

Green: "=[Sales_%] > 100"

Anybody can tell me what is the problem ? and how I can apply this conditional formatting using "Sum()"?

Thanks,

[Former Member]

This is how it works:

Red: "=[Sales_%] < Sum([Sales_%] IN Block)"

Green: "=[Sales_%] > Sum([Sales_%] IN Block)"

[Former Member]

HI

Create a variable for Sum([Sales_%]) and use that variable in formatting like below

Var x=Sum([Sales_%])

Red: "=[Sales_%] < x"

Green: "=[Sales_%] > x"

[Former Member]

Hello Hariharan

The formula does not accept the declaration statement "var x = Sum([Sales_%])"

I am getting the "The formula must return a Boolean or numeric value" message

[former_member207878]

Hi,

You have to put alerter separately on break level (where you are calculating averages of BU), as you have specified individual level.

Then you will get red/green images as per your requirement

Cheers

Sahil

[Former Member]

Dear Sahil

Can you explain your point more (may be including some examples)

Thanks,