2 Replies Latest reply on Aug 1, 2012 9:49 AM by Tracy Rodgers

    Running Sum

    Sara Murray

      Hi everyone,


      I'm having trouble with the running_sum function. Here is my equation:

      ((RUNNING_SUM( [Policy Number Count (Distinct)] ) / [Total Count] ) * (12/MONTH( [Termination Date] ) )


      I keep getting the error "All fields must be aggregate or constant when using table calculations or fields from multiple data sources"

      If I run it without the running_sum function, everything works. In my table the running_sum works just not the function.

      Anyone have any ideas?