Forum Discussion

Kfausch's avatar
Kfausch
Icon for Helper II rankHelper II
7 years ago
Solved

How to SUM a measure using MAX

I have a table in which I am trying to calculate product waste, the issue is I need to SUM the yield but only on the last entry for a particular document.   This is the forumla I am currently using...
Need Help
  • ThomVF's avatar
    ThomVF
    7 years ago

    I see what you mean - have you considered creating a deduped version of the table then calculating for each row, eliminating the dedupe inside the calc? 

ThomVF's avatar
ThomVF
Icon for Advocate IV rankAdvocate IV
7 years ago

Looks like it is giving you the last value calculated, not the MAX?

Are you using calculated columns or calculated measures?

 

 

 

Kfausch's avatar
Kfausch
Icon for Helper II rankHelper II
7 years ago

I am currently trying with meausures, but I tried to make it work with calculated columns as well.