Page 1 of 1

Summary Custom Field

Posted: Tue Nov 04, 2014 7:48 pm
by bdomanov
Hello,

I am working on making a summary custom field. To make it easier to discuss, ill simplify it down to just the SUM of X.

The field......"SUM" i want to be the overall sum for the sample set. As it is now, it finds the sum with only the previous values in the sample set
For example (currently):

U01: x=0 Sum=0
U02: x=1 Sum=0
U03: x=1 Sum =1
U04: x=1 Sum = 2
U05: x=0 Sum = 3

The custom field could be U%...SUM(X) and I want it to be 3 for all of the unknowns, but it only calculates at the unknown it is at:

U01 =0 (sum = 3)
U02 = 1 (sum = 3)
U03 = 1 (sum = 3)
U04 = 1 (sum = 3)
U05 = 0 (sum = 3)

I want the sum to be 3 for all of these samples, is there a way to get this to occur in this manner?

Re: Summary Custom Field

Posted: Wed Nov 05, 2014 6:31 pm
by benW
Hi bdomanov,
Which version of Empower are you using?
If you are using Empower 2, you should be able to get this to work by adding a summarize custom fields line at the end of your sample set, however in Empower (1154) this worked incremently... After Empower 2 FR5 and onwards you can choose to do either.
Hope this helps...
Ben