Syntax

[naziralala]

Count({<LastName = ('Smith'), HireDate>= {‘1/1/2013’}>} Distinct SalesPersonID)

What is the error?

[m_woolf]

need braces{} around Smith, not parentheses

[naziralala]

tried that.. does not work

[m_woolf]

are you getting an error or just not the results that you hoped for?

[naziralala]

It is showing as Error in modifier expression

[m_woolf]

The other thing that is wrong is the syntax for >=

It needs to be something like this:

HireDate= {‘>=1/1/2013’}

also set analysis is very picky about date formats. It might be better to use numbers for the comparison.

[naziralala]

This was helpful.

Thank You

[ankitaag]

=Count({<LastName = {'Smith'}, HireDate= {‘>=1/1/2013’}>} Distinct SalesPersonID)

[naziralala]

Thanks Ankita,

this works...

[ankitaag]

Hi Nazira,

Kindly mark any 1 of the answer as helpful correct so as to close the discussion