Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are missing { and } within your set modifier
=Num(Count({$<columnname = {'String'}>} NrLine)
Missing Parenthesis
=Num (count ({($ <columnname = {'String'}>} NrLine)
Or
=Num (if(columnname = 'String' , NrLine ) )
= Num (count ({$ <columnname = 'String'>} NrLine))
Try This
Try this.......
Num(Count({$<columnname = {'String'}>} NrLine))