6 Replies Latest reply on Nov 25, 2018 8:27 AM by Paul Wachtler

    If condition not working while creating reference line

    Rohit  Sharma

      Hi All,

      I am trying to create a reference line which always shows the US Average value in the Geography dimension as a Reference Line.
      I created a reference line using a calculated field :

      if [Geography] = 'U.S. Average'

      then

      ([JobGrowthRate jgr]-[PrevYrJobGrowthRate_jgr])

      /

      [PrevYrJobGrowthRate_jgr]

      END

       

      If I dont select US Average in geography it doesnot show me the reference line (attached both screen shot below), how should i write the expression so that It will always show us average even though it is not selected?

       

       

      Appreciate your help!