Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My requirement is to set the background color in a straight table. The background of the Dimenison or expression to be set with the RGB of the dimension itself.
Attached a sample app.
Creating a nested if is impossible since expecting lot of more entries.
Thanks is advance.
-Sundar
There should be some other way. Working on that. Mean while below works for time being.
=RGB(SubField(KeepChar(RGB,'123456789,'),',',1),
SubField(KeepChar(RGB,'123456789,'),',',2),
SubField(KeepChar(RGB,'123456789,'),',',3))
Regards,
KKR
How you gonna set the background color? is it based on some condition?
whey you click on the "#" sign at Dimension or Expression you
may define the textcolor to your likings
e.g. Expression textcolor rgb(255,128,128)
the dimension is iteself the color. I just want to set the dimension as the background color.
eg. 1st row - black, 2nd row - blue, thrid row - yellow, like wise...
I want the color of background to be dynamic in accordance with the dimension.
-Sundar
The text color or back ground color needs to be dynamic in accordance with the dimension.
Please refer to the attached sample app.
I donot see your attached app
what I did for a customer with a small masterdata Dimension (about 20 values)
I used an inline code where I attached for each value an own colour (rgb code)
then joined it to Dimension and thenI could use the colorfield in the Background Color field
I have no clue how to give each row another color
Sorry, my bad. Attached the app now. Please check , Am trying to replicate the same here, but looks like am missing something.
Please help.
-Sundar
There should be some other way. Working on that. Mean while below works for time being.
=RGB(SubField(KeepChar(RGB,'123456789,'),',',1),
SubField(KeepChar(RGB,'123456789,'),',',2),
SubField(KeepChar(RGB,'123456789,'),',',3))
Regards,
KKR
Great Works like heaven
Thanks a lot
-Sundar
Hi,
Need a 0 to be added to the string '1234456789,'.
Used an alternative shown below
Thanks again for the help
RGB(SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',1),
SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',2),
SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',3))
-Sundar