Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

EMP_PHONE EMP_TOWN EMP_ID
01628-198371Cookham307
01628-187632Windsor306
01628-782364Cookham305
01628-243535Maidenhead304
01628-567231Maidenhead303
01628-834582Maidenhead302
01628-764234Slough301
12-54-11-10New York209
22-52-22-00New York208
12-85-01-61New York207
12-33-51-29Long Island206
12-56-55-20New York205
14-44-11-66New York204
22-36-25-50New York203
22-54-11-10New York202
12-24-26-44New York201
14-54-11-10Los Angeles111

i loaded this data when i am using the text object to count EMP_ID its is showing actual text in the text box

in text box i use condition count(EMP_ID)

1 Solution

Accepted Solutions
Not applicable
Author

Hi

Did you use;

=count([EMP_ID])

The square brackets are important as well as the equal sign.


Regards


Steve

View solution in original post

3 Replies
Not applicable
Author

Hi

Did you use;

=count([EMP_ID])

The square brackets are important as well as the equal sign.


Regards


Steve

Not applicable
Author

Hi Vinay,

You will have to use '=' sign before count i.e.

=Count(EMP_ID) instead of just count(EMP_ID).

Hope this helps!


Not applicable
Author

Hi Steve,

Square brackets are not required because in your case, you have used _(like EMP_ID)..

So you can put an equal sign to make things work!