Need Help

[Anonymous]

Hi All,

Greetings,

I want to show % Change (this year vs last year) Positives values to be highlighted in Green and negatives in Red in horizontal bar chart. Can anyone help me.

Regards

Adarsh

[sunny_talwar]

Would you be able to share a sample to show what you have?

[Anonymous]

here this is the chart..............on right side

[neelamsaroha157]

If its about changing the color then you can use 'Background Color' option when you expand your expression and use calculation.

If((your_Calculation)>0, green(), Red()).

[Anil_Babu_Samineni]

What was the expression you defined for +ve and -ve values?

[Anonymous]

if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

)>0,RGB(77,167,65),RGB(255,113,113)..

I am trying this but it is not working

[Anonymous]

if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

)>0,RGB(77,167,65),RGB(255,113,113)..

I am trying this but it is not working