topic Re: Set Analysis function syntax - Help needed in App Development

Set Analysis function syntax - Help needed

alexis — Sat, 16 Nov 2024 20:01:55 GMT

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

Re: Set Analysis function syntax - Help needed

tresB — Mon, 23 Sep 2019 12:16:41 GMT

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)

Re: Set Analysis function syntax - Help needed

alexis — Mon, 23 Sep 2019 12:48:11 GMT

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

Much obliged

Alexis