# App Development

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Creator

## 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

Labels (3)

• ### Set Analysis

3 Replies
MVP
One obvious thing is to add = sign between ( and MakeDate... Can you try to see if that resolves your issue
Creator
Author