Forum Discussion

juanjosegarrido's avatar
juanjosegarrido
Regular Visitor
9 years ago

SUMX with multiple tables

Dear Community, There is a formula I have been looking for and can''t figure it out. I have several tables in my model for Projects, Contracts and percentage progress as planned and real progress.  ...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

juanjosegarrido

 

In this scenario, your Amount can map RealProgress properly. However, your Project has 1 to many relationship to plannedProgress, which means your Amount can never get a specific corresponding PlannedProgress. This is the reason why your formula can't work.

 

Regards,

  • juanjosegarrido's avatar
    juanjosegarrido
    Regular Visitor
    9 years ago

    Hi, thanks for your reply. Because there are more than one contract value, what would be a correct change in my data model?

    Maybe moving contract amount to Projects table?

     

    Regards.