2 Replies Latest reply on Nov 16, 2011 10:55 AM by David Klass

    Creating simple calculated field.

    David  Klass

      I am trying to create a simple calculated field where I would like to have the percentage where an item in the field [viewed] is viewed.  When it is viewed the system created a 'Yes' in the field.  Given that, I am trying the following calculation where the syntax is reported as correct.  However it seems that it is not counting the fact of the 'yes' but reports that in 100% of the time it is viewed.  I am doing something wrong?  Thanks for any help.  David

       

      COUNT([Viewed]='Yes')/count([Alert ID])*100