Expression error?

[#1]

Hi,

I have dimension and expression as below in straight table

Dimension: TeamMember

Expression: Count(DISTINCT {$<Source={'ITDepartment'},Order={ITDepartment'},Result={'Work Completed'},Flag={1}>}EmployeeID)

when I select the Date from 03/03/2014 to 07/03/2014 the count of the expression is showing 10 whereas in the database the count is showing 5. can anynone please tell me is there anything wrong in expression?

Thanks.

[MK_QSL]

Where you are getting 10?

Can I see that file please?

[PrashantSangle]

Hi,

You can do one thing,

take EmployeeID in list box then select your date range and check the frequency of EmployeeID

If it is greater than your expected count then might be it is issue of your data model.

[#4]

ok will send you

[#5]

Please see attached and let me know what is the problem.

[MK_QSL]

It is showing 10 because they are indeed 10.

Please check the enclosed file...

[#7]

You mean the count is correct? If so then for the same selections in access database the count is showing 10

Please can you clear my confusion.

EDIT: Moreover there is problem only with these two expressions. If I select other dates again the countof expressions is entirely different compared to database.

[MK_QSL]

Dont have idea about your access database.

But the file you have provided is showing the correct result.

[#9]

Thanks. This is really frustrating me . Even I tried with one table but still showing the same result.

[#10]

will it creates any problem to update the data refresh if I keep on relaoding the file every 2 minutes/5 minutes??