1 Reply Latest reply on Jun 25, 2018 1:10 PM by Jim Dehner

    Reference Lines

    Barb Reiser

      How do I add a reference line that would show multiple values based on the month? I tried the below calculated field but I can't seem to get that to work/display how I want it. So basically Jan-May the target will be 180, then Jun-Aug it will be 240, then Sept-Dec its back down to 180. 

       

       

      IF MONTH([Order Date]) = 1 THEN "180"

      ELSEIF MONTH([Order Date]) = 2 THEN "180"

      ELSEIF MONTH([Order Date]) = 3 THEN "180"

      ELSEIF MONTH([Order Date]) = 4 THEN "180"

      ELSEIF MONTH([Order Date]) = 5 THEN "180"

      ELSEIF MONTH([Order Date]) = 6 THEN "240"

      ELSEIF MONTH([Order Date]) = 7 THEN "240"

      ELSEIF MONTH([Order Date]) = 8 THEN "240"

      ELSEIF MONTH([Order Date]) = 9 THEN "180"

      ELSEIF MONTH([Order Date]) = 10 THEN "180"

      ELSEIF MONTH([Order Date]) = 11 THEN "180"

      ELSEIF MONTH([Order Date]) = 12 THEN "180"

      END