What is wrong in my expression?

[harleen_singh]

Attached is the sample.

If you look at the expression - (minus) i have used following formula.

count( DISTINCT { $< EmployeeNo = P ({< Date = {"$(MinDate)"}>} EmployeeNo )/ P ({< Date = {"$(Lastdate)"}>} EmployeeNo )>} EmployeeNo)

All the figures are correct but if you check company id 0102

it shows 1 in -(minus) which is wrong but when u make selection of 0102 it gives u correct figure i.e 3 .

I am completely stucked in this ? What is wrong in my expression ??

thanks

Lavi

[perumal_41 · Accepted solution]

Hi Lavi

I have attached one Application Please check is correct or not .i don't have your qvd.so iyour application take binary load,then employee table  Resident for companiation Employeeno and Company.This is field i used in Expression.

Regards

Perumal A

[harleen_singh]

@Perumal A,

                   it really worked perfectly man

thanks

Lavi