Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
The ">=......." was very helpful and that was where we were going wrong.
Much obliged
Alexis