I have a project I am working on and got stuck, I was wondering if someone could help? Thank you
I have 2 tables, a [HR _WRKF] table ,and [HR_TRNG] table. I am trying to determine what % of employees took the training?
Answer --> [HR_TRNG]/[HR _WRKF]...fair enough
My issue is when I apply a calendar to aggregate each count by YEAR in the filter pane, one of the table ID count changes. I think my issue may be in the calendar association but I am not sure... If there is any insight you can provide please assist and if you need more info do not hesitate, please ask.
I would like to thank you for your time and consideration. My silence shouldn't be taken as ungratefulness. I applied some of your suggestion and still didn't get the desired results, however I have been able to resolve my problem with "IntervalMatch". Intervalmatch [Effective_From_DT] and [Effective_To_DT]; I think associating these two fields helped identified each CURR_EMP_ID count . Thank you very much again... Cheers!!!