1 Reply Latest reply: Sep 7, 2016 5:38 AM by Yeo Poh sai

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

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

My QVF