Manipulate the color of the pie's of a piechart

[#1]

Gents,

I used this piece of coding in a chart to alter the background colour (on expression) of a pie but all turns into black.

if(GetCurrentField(#TEST) = 'R', rgb(0,128,0),
      if(GetCurrentField(#TEST) = 'A', rgb(255,255,0));

has onyone an idea how to get the right colours?

BR

M.

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

if(#TEST = 'R', rgb(0,128,0),
      if(#TEST = 'A', rgb(255,255,0));

Regards,

Kaushik Solanki

[sushil353]

is #Test is your field name? and 'R' , 'A' are the values of the field #TEST...?

Try this

if(GetFieldSelections(#TEST) = 'R', rgb(0,128,0),

      if(GetFieldSelections(#TEST) = 'A', rgb(255,255,0));

HTH

Sushil

[#4]

Thx Gents!!

All working now...