0 Replies Latest reply: Oct 25, 2016 2:59 AM by Thiru Palu RSS

    changing a formula will cause the misleading the background clour

    Thiru Palu

      Hi

       

      I have a scenario

       

      i need to highlet background colur based on year

      For example

       

      12

       

      means in 12 months one max and one min vlaue i need to highlet

       

      24

       

      means  i need to highlet 2 min and 2 max values

      like that  36 also

       

       

      i.e. for every 12 months i need to highlet  one min and one max value

      12 months   --- 1 min and 1 max

       

      24 months   -- 2 min and 2 max

       

      36 months   --  2 min and 2 max

       

       

      here attahced qvw file is having the code it's working for

      growth=(sales-prev_sales)/Prev_sales

       

      when i change the formula

      growth= sales-Prev_sales  it is not working you can see growth_test bacjkgorun formlua

       

       

      Please do the needful

       

      Thiru