If statment formulas on scatter graph

[#1]

Hi all,

I have created a few maps using google maps and scatter graphs with coloured pins using following formula:

If(count ([Asset.Serial #])=0, Red(), if (count ([Asset.Serial #])=1 , Yellow(),if (count ([Asset.Serial #])=2, Black() , if (count ([Asset.Serial #])=3 ,Black(), )))

Which works fine.

Howerver I now want to do the same but for a field value instead of a count and I cant seem to get the below to work:

If (Fieldvalue ([Activity.Type])='Demonstration', Red(),)

Many thanks

Paul

[bbi_mba_76 · Accepted solution]

Hi,

did you try with

If ( [Activity.Type]='Demonstration', Red())

or using the pick/match function

pick(match( [Activity.Type],'Demonstration'), Red()....