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

Employee
This discussion was created from comments split from: Need Help Calculating % Change (increase or decrease) Between Two Numbers.

• edited 03/19/24

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!