color If logic help

[mahitham]

Hi Experts,

Can any one please help me on below if logic to apply Grey Color.

I have a Flag with records 1 and 0.

When $(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Flag=1,Green(),

When $(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Flag=0,Red() else its Grey().

Please help me to apply Grey() in the below if logic. 

Aggr(

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=1,Green(),

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=0,Red())),Prod1Flag,Dim1,Dim2)

Thanks in advance

[Brett_Bleess]

Did you try the following:

Aggr(

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=1,Green(),

if( ($(vCount)/$(vTotalCount))>'20%' and $(Count)>5 and Prod1Flag=0,Red(),Grey())),Prod1Flag,Dim1,Dim2)

I am no developer, so I do not know if this is correct or not, but I believe that should account for things that do not match the first two conditions becoming grey in color.  Sorry if I am missing something here, if that is the case, if you can provide further details, or even a sample app, that may help others help you...

Regards,
Brett