Python Accumulate Values

ToddHenry1

In another post, I found this python script that creates a running total.  I was able to modify it to do a running product, but I need to have the running product reset when the value of another field changes.

How might I modify this code to do that?

• Calculate the accumulative value of a numeric field.
• Expression:
• accumulate(!FieldA!)
• Expression Type:
• PYTHON_9.3
• Code Block:
• total = 0
• def accumulate(increment):
• global total
• if total:
•   total *= increment
• else:
•   total = increment
• return total

My data is similar to this

95

ID	Value
1
1	9
2
2	5

The answer would be 1 = 81 and 2 = 25 in the 2nd row of each ID.

ToddHenry1

Below is the code I ended up using with some help from Tech Support.

This goes in the code block:

total = 0

LocationID = 0

def accumulate(locID, Inc):

    global total, LocationID

    if locID != LocationID:

       total = 0

       LocationID = locID

    if total: total = total*Inc

    else: total = Inc

    return total

In the expression I use accumulate(!LocationID!,!IncField!)

The LocationID is my grouping Field and the IncField is the one that gets multiplied together.