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

paulyeo11 — Wed, 07 Sep 2016 09:34:21 GMT

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

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

paulyeo11 — Wed, 07 Sep 2016 09:38:58 GMT

My QVF