Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Mahitham,
The problem probably lies in the 20% because you are comparing a value ($(vCount)/$(vTotalCount)) to a string 20%. This is not going to work. I've edited it to 0.2 (also 20%). Try this:
Aggr(
if( ($(vCount)/$(vTotalCount))>0.2 and $(Count)>5 and Prod1Flag=1,Green(),
if( ($(vCount)/$(vTotalCount))>0.2 and $(Count)>5 and Prod1Flag=0,Red())),Prod1Flag,Dim1,Dim2)
Other question, why do you use the Aggr?
Jordy
Climber
In which object are you using this? KPI or Table?
Jordy
Climber
Hi,
Then I would use the following formula:
if( ($(vCount)/$(vTotalCount))>0.2 and $(Count)>5 and Prod1Flag=1,Green(),
if( ($(vCount)/$(vTotalCount))>0.2 and $(Count)>5 and Prod1Flag=0,Red(),White()))
Jordy
Climber