1 Reply Latest reply: May 2, 2012 8:48 AM by sivaraj seeman RSS

    Sum a field by period in a script

    brandon breitling

      Hi Community,I have a field that I would like to sum the values of in a period to get the total of all previous periods combined.The period ranges from 1 to 26 and is called Period Number.  I want to have the value for period"x" to be total of x down to 1 peiords summed.  How do I do this in the script?Example with 3 periods.  First period feild value is 3 so total of it and all previous should be 3.  Second period field value is 1 so total of it and all previous is 4.  Thrid period field value is 5 so the total of it and all previous is 9.  I want to make a total so that any period I select, I can see the total of it and all the previous of the selection.