meaning of an expression

[#1]

hi

explain me the meaning of this expression. i have list boxes ename and eno in my document.

1)minstring({<ename={'ac'}>}empno)

2)firstsortedvalue({$} empno)

[CELAMBARASAN]

Hi,

     minstring({<ename={'ac'}>}empno) its fetches the empno of the employee 'ac'.

     firstsoretedvalue({$} empno) gives the first value of the empno sorted in ascending order.You used {$} here which is to fetch from the current selections but you can use simply firstsoretedvalue(empno) because automatically it considers selections.

Celambarasan

[#3]

i have a list box having empno as 5555,7648,5893 .

i am using an expression =numericcount({1}empno).

i am getting an output of 2 for all the cases.

how does this numeric count works???

[CELAMBARASAN]

Hi,

     NumericCount is to gives the count of the numeric values in that field.

     As of me numericcount({1}empno) will give you 3 because you have 3 numeric values 5555,7648,5893 You are using {1} here so it never consider any selections you made in any list box or field.{1} doesn't consider the selections you made.

Celambarasan

[#5]

now i have created a list box using empno.

the expression  i have used for it is =numericcount({$}empno)

i am getting 2 in front of every empno. why???

[CELAMBARASAN]

Hi,

     I think you have 2 record for each empno.Check with Distinct keyword.

     =numericcount({$} DISTINCT empno)

Celambarasan