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 Principal Consultant
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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!