10 Replies Latest reply on Aug 17, 2018 10:11 AM by Scott Carman

    Show Obligation at Max Date

    Scott Carman

      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