Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have written as follows:
=count({1<[Termination Year]={"=$(=(year(today())))"}>}([Employee Number]))
this should give count of employees terminated in year=current year. But it is not giving.
Is there any wrong in function used.
Try this may be:
=Count({1<[Termination Year]={"$(=Year(Today()))"}>} [Employee Number])
Try this may be:
=Count({1<[Termination Year]={"$(=Year(Today()))"}>} [Employee Number])
Try this: =count({1<[Termination Year]={$(=year(today()))}>} [Employee Number])
Hey
I think you have the expression wrong, it should be something like this:
=count({1<[Termination Year]={$(=year(today()))} >} [Employee Number])
If you want to affect the number by selection use this:
=count({$<[Termination Year]={$(=year(today()))} >} [Employee Number])
Regards,
MB
Check also this document:
http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting
hey as per the syntax there must be "=" before the $ right? If i place = it is behaving in correctly can u tell the reason?
hey as per the syntax there must be "=" before the $ right? If i place = it is behaving in correctly can u tell the reason?
Not always. When you are equating it to a number, I don't think you need that. But if You were saying >= or <= or <> then you will need it.