title: Spotfire Running Balance (Cumulative Sum)
body: <p>I am trying to create a running balance column in Spotfire that's supposed to look like the picture attached below. In essence,I want to calculate the cumulative total of the "amount" column row by row, and that I want it to start from 0 as the date changes. </p>
  
  <p>I have tried several OVER functions: 
  <code>Sum([AMOUNT]) OVER AllPrevious([Date])</code>
  <code>Sum([AMOUNT]) OVER Intersect([CURRENCY],AllPrevious([SETTLEDATE]))</code>
  <code>Sum([AMOUNT]) OVER Intersect([Calculation Date],AllPrevious([SETTLEDATE]))</code></p>
  
  <p>Any help is greatly appreciated. </p>
  
  <p><img src="https://i.stack.imgur.com/y9w3f.png" alt="Here is the Picture"></p>