AnsweredAssumed Answered

Function Not working properly.

Question asked by SeamusDoone on Mar 8, 2012
Latest reply on Mar 9, 2012 by SeamusDoone


Function Not working properly.


Hello I have a field on my database that should be stating whether the total invoice count for each year is showing an increasing trend or a decreasing trend.  Instead it is all over the place and not telling the right answer on some while it is on others.  There is no sense to it.

Current Equation:  =IF(${2009}>${2010}, "Decreasing", "Increasing")

What am I doing wrong?