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
Solution SpecialistWhat 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 IIThe column [quant] has the number of hours I can use in a particular project. the columns with the dates are the beginning and the end of the project. What I want in the end is a measure that gives me the nr of hours I can use per year in that particular project.
So this is what I am thinking:
1-I calculated how many days are between the two dates: column [nrdiasProjeto].
2-I divided the [quant] per [nrdiasProjeto] that gives me the average nr of hours I can use per day: column:[tempomediodia]
3- Know I would need a table with all the days between those dates and each day would have the average nr of hours allocated to them,
this way I coul them sum them by civil year.