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
