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!"
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.
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!
@gloria66
If you insist on using Multi-row Formula tool, we can do something like this with long conditional statement.
User | Count |
---|---|
61 | |
24 | |
23 | |
21 | |
20 |