Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago

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

  • 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.