Different color on pos

[#1]

Hi

I wonder if someone can help me. I want bars in a chart to turn red if they are negative and green if they are positive. I have added this code "=If(Sum(Avd.) < 0, RGB(193,0,43), RGB(0,128,64))" But depending if I write "<" ">" or if I write the green RGB or the red RGD first or second I only manage to get all the bars, both positive or negative, green or red. I've tried to ad two expressions but it doesn't help. Could someone help me?

Thanks in advance.

/A

[rajni_batra]

can u attach the app

[#3]

Check this Attachment which I hope helps you

[#4]

How do I just attach the app? Or more exactly, how to I extract it from the full document?

Thanks for the help.

/A

[#5]

I've tried to ad the code and it says it's correct (i've changed it to the colours I want), but the bars still don't get the right colours for possitive and negative...

Thanks for the help .

/A

[#6]

Find the Attached Document

[#7]

I wonder if the error is between these two expressions:

//Sum(BOKFBEL*_Flagga_DriftsUtfall)/1000

sum( {$<År = {$(#vThisYear)}, Månad = {"*"}, ÅrMån = {"*"}, KoddelB_Nivå1 = {"3", "4", "5", "6", "7"}, ÅrMån = {'>= $(#vÅrMånFirst)<= $(#vÅrMånNow)'}, Ansvar = {"*"} , Avd. = {"*"}  , Ansvar_Kod_Txt = {"*"}  >} (BOKFBEL) *_Flagga_DriftsUtfall)/1000

=if(sum(Avd.)>0,RGB(0,128,64),if(sum(Avd.)<0,RGB(193,0,43)))

Could it be that I should write something else instead of "sum(Avd.)"  in the second one? I'm from sweden so the "weird" language is Swedish.

Thanks for all the help.

/A

[#8]

Hello again

I got this to work with the expression =if(Utfall<Årsbudget,RGB(0,128,64),RGB(193,0,43)) but now I changed the name to "='Utfall ' & endTime" so I changed the expression to =if(='Utfall ' & endTime<Årsbudget,RGB(0,128,64),RGB(193,0,43)) but then it stopped to work. I've tried to ad and remove =, ', " and so on but it still doesn't work. Does anyone know what I've done wrong?

Thanks in advance.

/A