aggr with set analysis

[#1]

How i can write aggr funcation with set analysis.

My expression is--  count(aggr(if(count(index_id)>1,ID,emp_name,Sup_Name)))

Please help me urget basic.

Thanks in advance

Regards

Ashish

[sibin_jacob]

Hi Ashish,

Can you please elaborate your requirement.

Thanks,

Sibin Jacob.C

[tresesco]

Are you sure this is the right expression you are using? I guess there is some parenthesis issue.

[#4]

I want count(distinct id) where count(distinct index_id)>1

Regards

Ashish

[jagan]

Hi,

You missed on parenthesis

=count(aggr(if(count(index_id)>1,ID,emp_name),Sup_Name)))

I don't understand what you are doing with this, you are getting the count of SupName, you can also get the same by using below expression.  No need of Aggr().

=Count(DISTINCT Sup_Name)

Regards,

Jagan.

[jagan]

Hi,

Try this

Sum(Aggr(If(count(distinct index_id)>1, 1, 0), id))

Hope this helps you.

Regards,

Jagan.

[tresesco]

May be like:

Count( {$<id = P({1<index_id={"=count(Distinct inex_id)>1"}>} id)>} Distinct id )

If not this, please share your sample app.