topic Re: What is the correct approach? in App Development

What is the correct approach?

kunkumnaveen — Thu, 25 Apr 2019 10:58:43 GMT

Hi ,

I have to get done Cell colored in green for top 5 percentage values

Expression:

if(Dimensionality()=1 ,

if(rank(sum({<Year={$(vMaxCY)}>}Volume)
/
(sum({<Year={$(vPreCY)}>}Volume))-1)<=5,green(),rgb(201, 219, 189)

),rgb(201, 219, 189) )

Expression is Working Fine

But when i tried to expand any value the color getting disappear

So what correction should i need to do in my expression so that the color of Dimensionality 1 should remain green (861.08,49.08,34.52,14.55,9.73),even though the values are expanded .

Re: What is the correct approach?

zhadrakas — Thu, 25 Apr 2019 12:42:09 GMT

try this:
if(Dimensionality()=1 AND aggr(rank(sum({<Year={$(vMaxCY)}>}Volume)/(sum({<Year={$(vPreCY)}>}Volume))-1), YOUR_FIRST_DIMENSION) <=5
,green()
,rgb(201, 219, 189)
)

regards
tim

Re: What is the correct approach?

kunkumnaveen — Fri, 26 Apr 2019 03:49:23 GMT

Super Tim , it Worked Thanks , but to get colored Top 5 cells ,i need to set as <=6, if i set <=5 then only 4 cell r getting green colored.