1 Reply Latest reply: Sep 7, 2016 5:38 AM by PAUL YEO RSS

    How to make my Object change to red when i select competitor_k = Wago ?

    PAUL YEO

      Hi All

       

      My below expression work fine for return Net Profit vs Revenue Ratio % :-

       


       

      (

      (

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct NET_PROFIT_A_TAX_C)

      /

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)

      )

      -

      (

      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct NET_PROFIT_A_TAX_C)

       

      /

      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)

      )

      )

       

      /*

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct NET_PROFIT_A_TAX_C)

       

      /

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)

       

       

      I have convert the above expression into NetProfit vs Revenue as below :-

       

      $(vNet_Profit_Revenue_Ratio_Comp)

       

       

       

      I also Place the below expression at Value Color :-

       

       

      if($(vNet_Profit_Revenue_Ratio_Comp) <0 ,'#46C646','#d01919')

       

       

      Now the color keep display dark color , even if i select competitor = Wago or ADL . ( Wago will return -ve , ADL will return +ve )

       

      Hope some one can advice me where i go wrong ?

       

      Paul