Hi Gene,

Yes, there is a formula that can give you the correct % change in revenue from TY vs LY. The formula you are currently using () is not giving accurate results because it is not taking into account the direction of the change (i.e. whether it is a gain or a loss).

The correct formula to use is ((

Formula:

TY-LY 


)/

Formula:

ABS(LY) 


)*100. This formula takes into account the direction of the change and gives you the correct % change in revenue.

Here's how to use the formula step by step:

1. Select the cell where you want to display the % change in revenue.
2. Type the formula: =((
   Formula:

   TY-LY 

   )/
   Formula:

   ABS(LY) 

   )*100
3. Replace "TY" with the cell reference for the current year's revenue.
4. Replace "LY" with the cell reference for the previous year's revenue.
5. Press Enter.

The result will be the % change in revenue from TY vs LY, taking into account the direction of the change.