Forum Discussion
stackover
2 years agoFrequent Visitor
Combining running totals with selected date value
Hi guys. How are you doing? It has been a week that I am trying to do the following. I hope you guys can help me. - I have two running totals. One is a baseline and it should be static (problem n...
- 2 years ago
stackover
2 years agoFrequent Visitor
This calculates the accumulated man hour. The baseline is what was initially planned at the beginning of the project. The Database table represents the man hours carried out. When someone selects a date in the slicer, this will be the cutoff date between the realized man-hour and the man-hour forecast represented by the rest of the baseline data.
Then the line would continue to be a running total, in which the realized values would be the sum of the values in the database table plus the forecast (baseline table), which would be the sum of the values from the selected date until the end of the table Baseline.