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

System

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

John_Anetrella

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

AravindGP

Hi @John_Anetrella

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

John_Anetrella

I forgot the ) after the first function. Works fine now, thanks. Didn't need @row