4 Replies Latest reply on Jul 23, 2013 1:53 PM by Ryan Chauvin

    A Simple Table Analysis...

    Ryan Chauvin

      I have what I hope is a simple question, but I can't seem to figure it out, hopefully someone can help.

       

      I'd like to create a a calculated field or table analysis that lets me set a numeric (and static) goal. So as the data approaches the target, it'll calculate 1000 - (Field).

       

      Am I missing something really obvious? When I use the calculated field, it won't let me subtract from a number, only another field.

       

      Thanks in advance!