1 Reply Latest reply on Aug 2, 2018 8:50 AM by Ankit Bansal

    How to sum a measure for 2 different dates

    Elizabeth Benusa

      This question is specific for cash flow purposes. For Accounts Payables I have 2 dates for cash flow 1) when I expense items (like rent) so Posting Date and 2) when I actually pay the rent Invoice Date. That being said from an accounting perspective I am recognizing cash at 2 different points 1) when I expense that month and 2) when I actually pay. I am trying to figure out how to netout the cash flow/AP balance for each month based on the 2 different dates. Any suggestions?

       

      Measure: Accounts Payables

      Dates: Posting Date, Payment Date

       

      Thanks!