Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Need help with the multi row formula

Manjari
8 - Asteroid

I need help with calculating the % difference for the years for all groups. 

But the calculation should be restricted to a single group. How can I achieve this via Alteryx

Calculation ([Value]-[Row+1:Value])/-[Row+1:Value]

 

GroupsyearValueCalculation
A20202-0.33333
A20193-0.25
A20184-0.2
A20175 
B20203-0.25
B20194-0.33333
B20186-0.14286
B20177 
C202091.25
C20194-0.2
C20185-0.16667
C20176 
2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @Manjari ,

 

To make the calculation to restart on every group, what you have to do is group by the Group column in the multi-row tool configuration window.

 

AngelosPachis_0-1613469993117.png

 

Then you can use the expression you provided.

 

Regards,

 

Angelos

Manjari
8 - Asteroid

Thank you @AngelosPachis worked like a charm.

Labels