1 Reply Latest reply on Mar 19, 2014 9:24 AM by Eric Munisteri

    Multiple IF Statements or CASE [Parameter] Alternative

    Michael Lance

      Hi Friends,


      I know that it is possible to do this:

      CASE [parameter]

      when "string" then [field]




      However, I want to do this:


      if [field 1]>[field 1 criteria]

      then "yes"

      else "no"



      for multiple fields, each with their own criteria in one calculation.


      Is it possible?


      The problem with using CASE with a parameter is that the parameter only allows me to use the criteria for one field at a time and I have multiple fields displayed at once, each with their own set of criteria.

      The criteria are being used to apply colors to displayed values.


      Thanks in advance,