Aggregation in text box

[shruthibk]

Hi can anybody suggest how to use below expreesion in text object

=if(aggr(count( distinct issueid),exceptionid,[cob date])>1),

count(distinct  exceptionid)

The above expression gives desired result in chart but i am not able to achieve it in text object

my requirement is to find out count of exception id's if it is having more than one issue id

Thanks,

Shruthi

[sunny_talwar · Accepted solution]

May be try this

Sum(Aggr(If(Count(DISTINCT issueid) >1, Count(DISTINCT exceptionid), exceptionid, [cob date]))

[rubenmarin]

Hi, maybe with:

=if(Sum(aggr(count( distinct issueid),exceptionid,[cob date]))>1,

count(distinct  exceptionid))

[CarlosAMonroy]

Hi Shruthi,

You can try:

=if(sum(aggr(count( distinct issueid),exceptionid,[cob date]))>1,count(distinct  exceptionid))

Carlos M

[shruthibk]

Thank you all for your quick response