Hello,
I want to insert a Formula to accumulate the Amount for the same Member in the same Company and return the calculation result in each row. See example below. If the same Member changed to a different Company in any given period, the accumulation starts from 0 in the new Company. The expected results are placed in column "Accumulated".
Could anyone help with this scenario without using macros?
Thank you in advance.
Solved! Go to Solution.
Hey @gc-804, whilst this could be done with a Multi-Row Formula, the quickest way is to actually just use the Running Total tool. Within the configuration, you can set what you want this grouped by i.e. when to reset. The following gets you your desired output:
@gc-804
The Running Total tool is exactly for this purpose. 😁
This worked exactly the way I want. Thank you both so much for your help!!
Thank you for your feedback and good to know it works.