4 Replies Latest reply on Jan 22, 2019 3:17 PM by Chris McClellan

    calculated field logic help

    Tim Mullady

      Hello

       

      I wanted to see if someone can help me with a calculated field. 

       

      I'm trying to adjust Revenues in 2019, for ABC, after week 09/29/18.

       

      I'm trying to reduce  revenue 125 per pax for "condo"

      I'm trying to reduce  revenue  140 per pax for "property"

      Land can stay untouched

       

       

       

      IF  [Year] = 2019

      AND [BU] = "ABC"

      AND [Week] >= #2018-9-29#

       

      Then

      IF  [Type] = "Condo" then [Revenue] - ([Pax] * 125)

         ELSEIF [Type] = "Property" then [Revenue] - ([Pax] * 140)

               ELSEIF  [Type] = "Land" then [Revenue]

      End

       

      ELSE

       

      [Revenue]

       

      END