How do I show a 100% variance percent when the previous period is 0 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I show a 100% variance percent when the previous period is 0

I want to show 100% for the variance percent when the previous figure is 0. I am using the formula: eval(current period - previous period) / previous period.

In the 2 images, the first column (most left) is the current period. the second column is the previous period and the third column is the variance.

The fourth column is my current formula and the last column (most right) is the desired figure in image 2. How do I write a conditional formula that indicates when the previous value is 0 and the current period value is #, then populate positive 100% increase? Thank you in advance!

image 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!