
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MakeDate Set Analysis
Hi everyone! I need your wisdom,
Everything that those variables have is correct, the formula is correct, i know this because i have a chart that uses this formula in this way:
$(vNoBajasHastaFechaVistaCNDistrital)/
(($(vActivosxPeriodo)
+
$(vActivosxPeriodo)
+$(vNoAltasHastaFechaVistaCNDistrital)-$(vNoBajasHastaFechaVistaCNDistrital))/2)
I'm trying to calculate % turnover, the code above calculates it correctly, but it only works with one dimension (month), i need two dimensions (month and job position), so i try using the following code
$(vNoBajasHastaFechaVistaCNDistrital)/
(((Count({<FechaNum={"<=$(MakeDate($(vAño),MesN,1))"},HireTerm={'H'}>}Distinct EMPLOYEE)-
Count({<FechaNum={"<=$(MakeDate($(vAño),MesN,1))"},HireTerm={'T'}>}Distinct EMPLOYEE))+
$(vActivosxPeriodo)
+$(vNoAltasHastaFechaVistaCNDistrital)-$(vNoBajasHastaFechaVistaCNDistrital))/2)
This isn't the complete idea, but as far as i understand this sould be working and as you can guess it is not, i think that makedate can make this, but i don't know if i'm, using it correctly. Any ideas? I'm sorry for my english

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I already tried it, it does not work, the % is not the one i'm looking for

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Best,
Sunny
