Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

General Discussions

Discuss any topics that are not product-specific here.

NEED HELP WITH SUBTRACTING ONE ROW FROM ANOTHER

Tala
7 - Meteor

Hello everyone! I am looking for ideas to subtract one row from another. I have a column for the "fiscal year" and another for the "hours" worked.
I want to compare the number of hours worked in a certain year with the number of hours worked in a previous year by subtracting them.
I want it to be DYNAMIC and to still be connected to all the other data I have. So for example:

"Fiscal Year" "Hours"
FY22 10
FY22 12
FY23 7
FY22 15
FY19 20

Then I want the (sum of hours worked in FY22- sum of hours worked in FY23).

2 REPLIES 2
caltang
17 - Castor
17 - Castor

Like so?

 

image.png

 

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

@Tala did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels