Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
attached file may give you the idea to proceed further