Color using GetCurrentField()

[Anonymous]

Hi,

I have a RGB set for one dimension, but I'm working on a Pie Chart with two dimensions. Now, If I set the expression color based on the RGB(R, G, B) when I drill-down in the group all the colors are gone (it looks black). How can I have the RGB for the first dimension and like random colors for the second one (can be the original ones).

I tried this expression:

If(GetCurrentField([Actividad-Oportunidad]) = 'Oportunidad', RGB(R, G, B), RGB(R * rand(), G * rand(), B * rand()))

But I didn't like the result.

Thanks in advance, kindest regards.

[Nicole-Smith · Accepted solution]

What about this instead:

If(GetCurrentField([Actividad-Oportunidad]) = 'Oportunidad', RGB(R, G, B), RGB(255 * rand(), 255 * rand(), 255 * rand()))

[Anonymous]

Thanks!!! that worked better!