1 Reply Latest reply: Nov 6, 2013 6:04 AM by Michele Barini RSS

    If statment formulas on scatter graph

      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