3 Replies Latest reply on Jan 24, 2019 1:52 PM by Matt Livingston

    Two Date Fields - Fix value in row for one date field perform logic check across all rows for other date field

    Matt Livingston

      Hello,

       

      Please see attached twbx with simplified data.

       

      Title says it all - Trying to perform logic check in order to sum(Amount Spend) for a given date field ("Change Date" in this example) based on if any row (not just the row with that value of Change Date) has a date value in the "Of Day" column that is less than that value of "Change Date"

       

      Thanks for the help.

      -Matt