3 Replies Latest reply: Dec 5, 2014 5:46 AM by Adam Booth RSS

    conditional colors in Bar Chart

      Hi all

       

      I tried to change color in a bar chart for Min and Max with following formula:

       

      =if(sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)/Count (DISTINCT Fact.Order)={'$(=Min(sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)/Count (DISTINCT Fact.Order))'},RGB(255,0,0),RGB(0,0,0))

       

      Could somebody helpm me with the formula?

      thanks

      Oliver