1 Reply Latest reply on Sep 22, 2015 4:26 PM by Alexander Mou

    How can I merge two Date Fields that share a Value field on one worksheet

    Sean Song

      Hi all

       

      I'm trying to solve for running totals of Investment's out of the business at the end of each month.

       

      This is a function of Money Invested, minus the amount of money which has been repaid to investors within that same month.

       

      The problem is that all Investment values come from one Amount field. But the invested numbers come from one time line (Created At), while the amount repaid comes from another time line (Date Repaid).

       

      So if I want to take running totals, this creates a problem as the data reads from either the created at time field or the Date Repaid time field. Is there a way I can merge the two time lines?  

       

      Any help would be much appreciated.

       

      Thanks Ladies and Gents.