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,
Try like this:
if(avg(Value) > avg(Total aggr(avg(Value), Name)), Red(), Green())
Thanks Pratik ,it works for me