Morning All,
My project is trying to show the state of a contract for my company. In this part of my project I am trying to show the obligation amount at the Max transaction date. I got the Max transaction date via a LOD calculation. The problem is that when I add in the Obligation Amount, it is summing the entire column, not at the row level where the obligation amount = max date.
Attached is a workbook with made up data as I can't show you the real thing.
Thanks in advance for your help!
Scott
12 Antworten
Hi Scott,
Depends on what you want to display...if you need to see all values, then the below approach will work, otherwise if single row then Deepak's solution will work:
