Forum Discussion
Circular Dependency was detected
Hi Good day,
An error on my measure
Im trying to get an output.
1. How can i get the diffirence manHrs of today data if yesterday data overide by today data?
Yesterday - Today = sum of Diffirence (A)
2. How can i distribute the sum of diffirence per row on my table.
Sum of Deffirence (A)/no. of day remaning (B) = (C)
Where no. of day remaining (B) = 3
2-13-24
2-14-24
2-15-24
so the outcome will be.
2-13-24 + C
2-14-24 +C
2-15-24 +C
it possible to distribute the manHrs on the following days after the current date to max date of my plan, let say in this case taday is Feb-13 so it will distribute from Feb-14 to 17. and the divisor 4 (Feb-14 to 17).
Sample Table below.
any to possible way to have same result if this method wont work?
Thank you in advance
Allan
1 Reply
- danextian
Super User
Hi AllanBerces
Can you please post a workable sample data and not an image? You may post a link to an excel file in the cloud.