How can I show dependancy of two fields with if condition

[#1]

If count(field A) =1, field B should be green otherwise red.

looks very simple but not working out....

Can some one give me the script for this.

[sunny_talwar]

In the script? What are going to color in the script? Can you share a sample to show what you are trying to do?

[ahaahaaha]

Hi,

May be like as at attached file?

Regards,

Andrey

[#4]

I am building a working load Employee map with the office and Customer service Employee fields.

So, If an office is visited by more than one CSE, office should be displayed in one color , if more than one CSE, office should be displayed in different color. I am using these two images

If count(CSE) =1, Office should be blue.png otherwise green.png.

[#5 · Accepted solution]

IF(COUNT(DISTINCT CSE)=1, 'blue.png', 'green.png')