function inside function

[#1]

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.

[sunny_talwar · Accepted solution]

Try this may be:

=Count({1<[Termination Year]={"$(=Year(Today()))"}>} [Employee Number])

[Gysbert_Wassenaar]

Try this: =count({1<[Termination Year]={$(=year(today()))}>} [Employee Number])

[miguelbraga]

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

[miguelbraga]

Check also this document:

http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting

[#6]

hey as per the syntax there must be "=" before the $ right? If  i place = it is behaving in correctly can u tell the reason?

[#7]

sunindia‌

hey as per the syntax there must be "=" before the $ right? If  i place = it is behaving in correctly can u tell the reason?

[sunny_talwar]

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.