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

Running Sum

Sara Murray Aug 1, 2012 9:29 AM

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?

Thanks,

Sara

1. Re: Running Sum

Sara Murray Aug 1, 2012 9:36 AM (in response to Sara Murray)

Another way I could do the formula would be to use:
RUNNING_SUM( [Policy Number Count (Distinct)] ) * (12 / MONTH( [Termination Date] ) )

but the running_sum function isn't working for that either.
Like Show 0 Likes(0)

Actions
2. Re: Running Sum

Tracy Rodgers Aug 1, 2012 9:49 AM (in response to Sara Murray)

Hi Sara,

The following article should give some insight on resolving this issue:

http://kb.tableausoftware.com/articles/knowledgebase/calculation-error-resolving-aggregate-nonaggregate-arguments

The calculation should be edited to look similar to the following:

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

Hope this helps!

-Tracy
Like Show 0 Likes(0)

Actions

Tableau Community Forums