issue with pie chart background color

[#1]

hi

i have written condition like below

if(so_state='Active',Green(),

if(so_state='Cancelled',yellow(),

if(so_state='On Hold',blue(),

if(so_state='Closed',red(),white())))

here i haven't mentioned  the black color even though chart showing black color by default like below image .please help out on this.

Thanks

siddu

[sunny_talwar · Accepted solution]

The pie chart area that is getting selected at black, is that on-hold section? Can you make sure you have all the casing right for on hold and no dash or anything like that... Also check for white space before or after.

[maxgro]

add a   ) at the end

if(so_state='Active',Green(),

if(so_state='Cancelled',yellow(),

if(so_state='On Hold',blue(),

if(so_state='Closed',red(),white()

))))

[agni_gold]

Whatever condition will not full fill , it will take default color , so you can change default color as different or make your condition more.

[#5]

when i am applying

=IF(GetCurrentSelections(state)>0,color(FieldIndex('state',state)),color(FieldIndex('state',state)))

it's works fine but when i am reloading the application the colors of the changing by default

[#6]

yes i.e is on-hold section .i have checked every thing is fine @sunny