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