Using the Multi-Row Formula to calculate the sum of 4 quarter."

[gloria66]

hello, 

I would like to use “Multi-Row Formula ”to calculate the sum of data for 4 quarters, as shown in the image. anyone can tell me how to write the formula? Thank you!"

[davidskaife]

Hi @gloria66 

You're better off using the Summerize tool and joining the results back on:

I've attached the workflow example for you. Also included an example of calculating the running total if you need that.

[gloria66]

hi DavidSkaife , THANKS SO MUCH!

BUT The reason I would like to use Multi-Row Formula is that I need to calculate a rollback of 4 quarterly figures once per quarter, as below, and I don't want to re-tune the programme each time I run it, do you have any suggestion ! thanks!

[Qiu]

@gloria66 
If you insist on using Multi-row Formula tool, we can do something like this with long conditional statement.