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

    If statment formulas on scatter graph

    Paul Lawrence

      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