Forum Discussion

Coffee1234's avatar
Coffee1234
New Member
2 years ago

Negative Goal Growth

Hi,  I have a report that I am working on where I am struggling with the logic a bit.   Store #                      $ Variance (Actual-LY).          Growth Goal.          % To Goal - E...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
2 years ago

hi Coffee1234 ,

 

this is indeed an issue. there are some recommendations like:
https://www.excelcampus.com/functions/percentage-change-formula-negative-numbers/

https://www.wsj.com/public/resources/documents/doe-help.htm#netincome

 

here i quote:

A positive percent change is represented in green, while a negative percent change is displayed in red. Percent change is not provided if either the latest period or the year-ago period contains a net loss.