Set Analysis function syntax - Help needed

[alexis]

Hi

I am creating a KPI that counts the number of staff as in:

= count(distinct(StaffName))

however I want to restrict the count to those members of Staff who started work (StartDate) on a date greater than or equal to a date held in memory, as in:

StartDate >= $(vFYStart)

The "StartDate" is stored as a date (dd/mm/yy) and the variable is stored as a number 63647 (the numeric representation for 1/7/2018).

My Set Analysis should be something like:

=Count({$<num([StartDate]) >= {$(vFYStart)}>}StaffName))

or something like that. I have tried all the possibilities that I could think of and nothing works. Any ideas?

Regards

Alexis

[tresB · Accepted solution]

Your have to format the variable data instead. Try like:

vFYStart = Date(<your already existing expression>, 'DD/MM/YY')

and the expression like: 

=Count({$<[StartDate]= {">=$(vFYStart)"}>}StaffName)

[alexis]

The ">=......." was very helpful and that was where we were going wrong.

Much obliged 

Alexis