Percentage Increase/Decrease
Hi there, I've looked at some other answers in the community but none seem to work for me.
I'm trying to determine the % increase or decrease of values Year Over Year. Here's an example:
THIS YEAR, we have a sheet that shows $125,000 in revenue. This time last year on a separate sheet, we showed $225,000. How do I create a formula to calculate the difference in % increase/decrease?
THIS YEAR sheet has column Actual QTD
LAST YEAR sheet has column Actual QTD
Answers

Kia ora,
Have you created a metrics sheet to pull the information from both sheets to then do a formula?
KL

I haven't, no... I thought I could just pull values from each sheet in a formula?

Is it just the one cell you want to evaluate from the second sheet?
If so, you could create a crosssheet reference that points just to that one cell! Then you can create your calculation between {this cell} and the one [in the sheet]@row
See: Create cross sheet references to work with data in another sheet
Does that make sense?

@Genevieve P. I have tried that yes, but it still gives me incorrect data. Can you perhaps tell me what formula to use to ensure I'm doing it correctly? You can use VALUE A and VALUE B as placeholders, and I can fill them in with my cell info.

No problem!
"Incorrect Data" sounds like your formula may not be able to read your numbers as numbers, but instead sees them as text (e.g. if the "$" sign was manually added instead of using cell formatting). Could that be possible?
Here's a simple formula I used, with {Value A of 20} selecting one cell in another sheet that has the number 20 in it.
If you're still getting an error, can you post the formula you're currently using so I can understand the math you'd like to achieve?

Thanks so much @Genevieve P. ! I wound up just copying the data and running an easy division formula instead. There were only a few lines from another sheet to reference, so it ended up being easier. Appreciate your help though as always!

No problem! I'm glad you figured out a way to get your desired result 🙂
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!