9 Replies Latest reply: Aug 6, 2012 2:32 PM by Rebecca Molstad RSS

    Need help finding error in logic

    Rebecca Molstad

      Hello Everyone,

       

      I have several tables that show Total Revenue (sum of RevDollars) for a certain year (Year) by the year a contract was signed (StartDate). I can't find anything wrong with my expressions, but they aren't pulling correctly, so I am obviously missing something. I have attached a sample file - any help you can give me would be greatly appreciated. I am sure the problem probably lies within the null StartDate values, which I am including as older than  2007, but I can't find where the problem is.

       

      Thanks!!