One measure depend on other measures

[zhaohaifeng]

Hi All,

Now we have the requirement , for the employees they have performance A/B/C,

if two or more performance are -1, like Frank as below then we set red background color;

if one performance is -1, like Tony as below then we set Yellow background color;

If all the performance is 1 like Emily as below then we set Green background color;

How can we write the expression for the requirement? Thanks in advance.

Haifeng

[PriyankaShivhare]

if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))

Thanks,
Priyanka

)

[zhaohaifeng]

Thanks for your help.

But maybe have the performance -2,-3,2,34..etc in the future, its better to judge for performance <0 or >0, do you have any ideas? Thanks.

Haifeng

[PriyankaShivhare · Accepted solution]

May be Like this

u can manipulate column itself

if(PA>0,1,-1),if(PB>0,1,-1),if(PC>0,1,-1)

then use

if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))

Thanks,

Priyanka