Forum Discussion
Kfausch
Helper II
Helper IIHow 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...
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
Advocate IV
Advocate IVI 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?
KfauschHelper II
Helper IIThis took a while, but I was able to make it work this way. I feel as though there must be a formula that can be used, but I am happy it is working. Thank you for your suggestions!