Forum Discussion

AlexDawson111's avatar
AlexDawson111
Frequent Visitor
3 years ago

Totals Summing All Table

Hi,   I have the following data. I would like the max remaining labor units to sum correctly. When i use the sum of the remaining labor units its summing the whole of the table.   Green Values ar...
Need Help
AlexDawson111's avatar
AlexDawson111
Frequent Visitor
3 years ago

Thanks for the reply, i have tried the following. 

 

SUMX is too high  

 

 

SUMMARIZE shows the following

 

 

Thanks

  • Yossarian's avatar
    Yossarian
    Helper I
    3 years ago

    Hi AlexDawson111 ,

     

    Yes, when I said to summarize the table, it was for you to summarize the table inside the previous formula. Specifically:

     

    SUMX ( SUMMARIZE ( ... ), [Max of Remaining Labor Units] )

    See if it works. If it doesn't, please specify how you calculate this [Max of Remaining Labor Units] measure.