Forum Discussion

WulffJoergen's avatar
WulffJoergen
Icon for Helper I rankHelper I
3 years ago
Solved

Total Sum based on max value from another table calculates correctly row by row but overall sum is

Hi Community, My model has different versions of the budget, and version number can vary based on project and department. And I desperately needs help to solve the problem. Regards Jørgen The cod...
Need Help
  • WulffJoergen's avatar
    WulffJoergen
    Icon for Helper I rankHelper I
    3 years ago

    I tried to replicate your data, and when I make the same table I Succeed. When I take my own data and rename and only keeps the columns as you have them, it does not work. Any ideas?

     

  • WulffJoergen's avatar
    WulffJoergen
    Icon for Helper I rankHelper I
    3 years ago

    Hi, 
    A little bit of reengeneering and then it worked like a charm 😊. 
    An Idea for an extra blog for you could be the same solution but with multiple filters included (like budget and project).
    Regards 
    Jørgen