This content has been marked as final. Show 3 replies
I have following table :
I want value to be colored based on Condition .
My condition is if value is greater than avg(value) ,it should be red else Green.
I have manually used average value in following expression : if ((value) > 30 ,Red(),Green()) ---- output : 45 and 55 are red others are green
I also tried with if ((value) > Avg(value) ,Red(),Green()) ---It is giving all values as Green color .
I want to calculate expression dynamically (avg value),
Thanks & Regards,