Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a chart which show the NP% trend.
Now all the % show 0.0% , which is wrong.
May i know how to make the number display out ?
Paul Yeo
1 Solution
Accepted Solutions
Something like this?
Expression used
(
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'TDS','OMRON','iLeaptron','PRECICON'}>}distinct NET_PROFIT_A_TAX_C)/10
/
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'TDS','OMRON','iLeaptron','PRECICON'}>}distinct REVENUE_C)/10
)*100Something like this?
Expression used
(
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'TDS','OMRON','iLeaptron','PRECICON'}>}distinct NET_PROFIT_A_TAX_C)/10
/
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'TDS','OMRON','iLeaptron','PRECICON'}>}distinct REVENUE_C)/10
)*100