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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Coffee1234 

May I ask if you have solved your problem? According to your description you are confused with the logic of calculating the % To Goal column when you have a negative value in the Variance column, in fact the divisor of the growth rate has to be a number greater than or equal to 0, otherwise this % To Goal is meaningless. You might consider displaying it as a numeric value only instead of a percentage.

 

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum