Set Analysis problem on syntax

[brunopaulo]

Hi Community,

I'm trying to solve a problem using Set Analysis. I want to count the number of rows that a certain value appears.

I'm writing this way:

= Num (count ({($ <columnname = 'String'>} NrLine)

In Load I created a fuction RecNo () as NrLine.

The error it gives me is: Error in set modifier ad hoc element list: ',' or ')'

I can not find the place to put it.

Thank you for attention
Regards
Bruno Paulo

[sunny_talwar]

You are missing { and } within your set modifier

=Num(Count({$<columnname = {'String'}>} NrLine)

[its_anandrjs]

Missing Parenthesis

=Num (count ({($ <columnname = {'String'}>} NrLine)

Or

=Num (if(columnname = 'String' , NrLine ) )

[Anonymous]

= Num (count ({$ <columnname = 'String'>} NrLine))

Try This

[hari8088]

Try this.......

Num(Count({$<columnname = {'String'}>} NrLine))