Need Help Calculating % Change (increase or decrease) Between Two Numbers

Answers
-
I am tracking project start dates and slippage
I want to determine the percentage increase or decrease between two numerical values
=[CURRENT QUARTER]1 - [ELT DATE STAT]1 / [ELT DATE STAT]1 * 100
(FINAL VALUE) CURRENT QUARTER VALUE = 3
(ORIGINAL VALUE) ELT DATE STAT VALUE = 5
PERCENTAGE DECREASE SHOULD BE 40% decrease?
THE ABOVE FORUMLAW YIELDS -97
WHAT AM I DOING WRONG HERE? COLUMNS ARE NUMERICAL
-
You can try this and make the column formatted as a percentage. Since it is a decrease, it will show in the negative.
([Current Quarter]@row - [ELT Date Stat]@row)/[ELT Date Stat]@row
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
I forgot the ) after the first function. Works fine now, thanks. Didn't need @row
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!