Number of fields calculation

[Anonymous]

Guys,

I have a table as shown below,

I want to get the count of FieldName for the fields which are having same WithPropID.

As per this data, I need the result as 1 - FieldName (SHPM_IDEN_NO) having same WithPropID (4).

Thanks,

Siva.

[m_woolf]

=count(<{FieldName={'SHPM_IDEN_NO'}}> WithPropID)

[vinieme12]

Can you post the sample in excel and also the expected output!

[Anonymous]

No, I don't want the count of WithPropID. I want the FieldName count which has same WithPropID.

[Anonymous]

Attached sample data, and my output is 1.

i.e Count(FieldName) which has same WithPropID.

[antoniotiman]

Hi,

maybe this

=Count({<FieldName={'=Count(DISTINCT WithPropID)=1 and Count(WithPropID) > 1'}>} DISTINCT FieldName)

=Concat({<FieldName={'=Count(DISTINCT WithPropID)=1 and Count(WithPropID) > 1'}>} DISTINCT FieldName,' - ')

Regards,

Antonio

[vinieme12]

Try below , this will check for exact combination of each value in Fieldname, WithPropID and Length

Dimension

Fieldname

Expression

=sum(AGGR(if(count(DISTINCT TOTAL <FieldName> FieldName&Length&WithPropID)=1 and count(FieldName)>1 ,1,0),FieldName))

or if you only need fieldname and withpropid combination, remove length from the expression

sum(AGGR(if(count(distinct total  <FieldName> FieldName&WithPropID)=1 and count(FieldName)>1 ,1,0),FieldName))

[Anonymous]

Thanks Vineeth. But using this expression, I couldn't expect my output.

[vinieme12]

works for me!