Hi guys, I want to set up a Reference line Value in a graph in a manner that if USP is Greater than AVAL it takes the value of USP otherwise it returns AVAL Value here is my Expression:
if ( Avg(Aggr(( if ([qtl_statistics.PARAM]='PRENDVIS',USP)), USP)) > Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',AVAL)), AVAL)),
Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',USP)), USP)),
(Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',AVAL)), AVAL))))
USP and AVAL Values are obtained after aggregation of PARAM Column