Formula Based Coloring Help

HCL Domino Domino Forum
1

I’m having trouble getting the conditional color change function to work while displaying my data. Instead of showing the variable value, it’s listing the RGB code in the column along with changing the color based on the value of my variable. Here’s my code:Red := 255:0:0;

DkGreen := 0:160:0;

@If(FPY > 90; DkGreen; Red)

so I get 255:0:0:0:0:0 or 0:160:0:0:0:0 in either Red or Green (depending on the value of FPY) in the column instead of the value of FPY in Red or Green.

I can sort of get it to work using:

Red := 255:0:0;

DkGreen := 0:160:0;

@Do(@If(FPY > 90; DkGreen; Red);(@ToNumber(FPY_Pass_Qty)/@ToNumber(Job_Quant)*100))

but instead of getting the value of FPY in red or green, I get either dark red or light red. Any help would be greatly appreciated! Thanks.

2

Subject: Formula Based Coloring Help

Use one hidden column exclusivly for setting the color.

In the column properties, check “Use value for color”. Use your formular to set the appropriate color. This color is in a effect and applies to all the following columns until you use another exclusive column to change the color again.

3

Subject: RE: Formula Based Coloring Help

Worked like a charm, thanks!

4

Subject: RE: Formula Based Coloring Help