Forum Discussion
Advocate IIDate multiplications
What is the reason, that you can!t get it to work?
By the way, what is the purpose to do this data transformation? Why you need this column?
Pavel
Advocate IIThank you for the help but that is not exactly what I need.
I know the hours dedicated to the project...they are in column [quant]. For example for the project id 57156 I will have a total of 5 hours for that project, but the project starts in 13_04_2016 and ends in 01_01_2020. That means I will have to divide those 5 hours for that period. I need to find a way to divide my 5 hours for the project duration and them sum them by years.
Thank you
Super UserWhat is the logic to divide those 5 hours across years?
- inescosta
I need to compare the hours allocated to a project in a budget and the real hours used. In each year I can only use [quant]/duration of the project.
- inescosta
Maybe if I find a way to unfold the time period between [inicioProjeto] and [FimProjeto] in order to recreate a table with all the bussiness days between the two dates.
My final goal is to multiple the [tempomediodia] by each days in a civil year (between those dates).