Turnover span for a unit

[mats_kroky]

Hej,

I’m writing here to ask for help me with a formula. I would like to count number of units were turnover rate is between 5% and 25%. Unfortunately, I’m not getting any positive results. What I get is all units that [BAL_TURNOVER_GRP FY19]={'YES'}

Count({<turnover_rate={'>=0.05','<=0.25'}, [BAL_TURNOVER_GRP FY19]={'YES'}>} distinct BU)

Turnover_rate is a variable and it looks like this:

Count({[BAL_TURNOVER_GRP FY19]={'YES'}>} CW_PERSNO_TM)

/

((Count({<[BAL_TURNOVER_GRP FY19]={'YES'}>} CW_PERSNO_Start)+Count({<[BAL_TURNOVER_GRP FY19]={'YES'}>} CW_PERSNO_End))/2)

Data is not aggregate so the raw data are 3 files: 1) all terminated co-workers in last 12 months, 2) co-workers list at beginning and 3) co-workers list at the end of 12 months period.

Any ideas?

Best regards,

Mateusz

[StarinieriG]

Hi,

if turnover_rate is a variable, try this expression:

Count({<[BAL_TURNOVER_GRP FY19]={'YES'}>} distinct 

If(

$(turnover_rate)>=0.05 and $(turnover_rate)<=0.25, BU))

[mats_kroky]

Hej,

No luck. There is no result returned. I have also tried by replacing the variable with a formula that stands after it but also no result was returned. 

I have a question to your answer - what does the $ symbol do?

Best regards,

Mateusz