Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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