6 Replies Latest reply on Jan 19, 2016 9:40 AM by Rajeev Pandey

    Calculated Field - Nested Calculation in If Then Statement

    Scott Hutchins

      Hi all,

       

      Having problem with a calculated field I'm trying to create and haven't been able to find any clarification via the oracle.

       

      Ideally, it would look something like the below but the calculation shows as invalid:

       

      IF [Ship Type] = "Bulk" THEN 5*[Size]^12

      ELSEIF [Ship Type] = "Tanker" THEN 4*[Size]^16

      END

       

      It doesn't like that i'm trying to enter a calculation after the THEN. Does anyone know how to fix this or can think of any work around?

       

      Cheers, Scott.