We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

gloria66
5 - Atom

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!"

 

捕获.JPG

3 REPLIES 3
davidskaife
14 - Magnetar

Hi @gloria66 

 

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

 

Capture.PNG

 

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

gloria66
5 - Atom

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!

捕获2.JPG

Qiu
21 - Polaris
21 - Polaris

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

0213-gloria66.png

Labels
Top Solution Authors