straight table issue

[Anonymous]

Hi..

I create straight table it has some values.

Please find following attachments..

in Repeat calls column initial it shows one value when i pressed perticular value it shows different value..

please help me

Thanks.

[Anonymous]

Hi

Change the expression to like this

Exp1:

num(count(distinct SESSIONID),'#,##0')

Exp2:

count  ({<CLI={"=count(CLI)>1"}>}   CLI)

[nizamsha]

= Hi  Chandini u can try this one

sum(aggr(if(count(CLI)>1,1,0),CLI))

[Anonymous]

Hi,

Is there any specific reason you are using below script, instead you can use simple Count(CLI) which will resolve your issue.

Count({<CLI={"=Count(CLI)>1"}>} CLI)

[Anonymous]

Hi Nijam..

Yhanks for your response..

please find following attachment..

[nizamsha]

=sum(aggr(if(count({$<CLI=,Rep_Details=,Date=,HUB=>} CLI)>1,1,0),CLI))Try This One

[Anonymous]

No nijam the value getting change..

thanks...