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]

      ...

      end

       

      However, I want to do this:

       

      if [field 1]>[field 1 criteria]

      then "yes"

      else "no"

      end

       

      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,

      Michael