Using of IF with a selection in a field

[alec1982]

Hi.

I am trying to build an if statement as follow:

= if(sum(if([Status]<>'Completed',[Sales]) >= 10), '..\images\sm_red_traffic_light.png',

    if(sum(if([Status]<>'Completed',[Sales]) <=5 ) & sum(if([Status]<>'Completed',[Sales]) >10 ), '..\images\sm_amber_traffic_light.png',

     if(sum(if([Status]<>'Completed',[Sales]) < 5), '..\images\sm_red_traffic_light.png')))

if the sum of sales is more than 10 while the status is completed then show the first image.

if the sum of sales is more than 5 and less then 10 while the status is completed then show the second image.

if the sum of sales is less than 10 while the status is completed then show the third image.

Not sure why it is not showing the right data.

Thxs,

[chematos · Accepted solution]

Try and instead &

[alec1982]

Worked perfectly!

Thxs,