Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have defect table and displaying top3 defect owners name list in single text object.
Now I want to display top3 owners defect counts also in the same text object.
below one currently using for displaying owners name list,
Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & chr(10)))
IF ANYONE HAVE IDEA TO MODIFY THE ABOVE EXPRESSION,PLS SHARE
THANKS,
Prakash
Hi,
Try like this
Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,Sum(passed) & chr(10)))
Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & ' ' & Sum(passed) & chr(10)))
Hope this helps you.
Regards,
Jagan.
=CONCAT(IF(Aggr(Rank(SUM(passed),4),executedby)<=3,executedby &CHR(10)),'',-Aggr(SUM(passed),executedby))