1 Reply Latest reply on Mar 26, 2013 5:21 PM by Dan Huff

    Calculated Field with multiple criteria

    Jesse LaBoda

      I'm trying to sum all negative values based on the three additional criteria's; week, year and value is less than. The formula I have written is below, but it doesn't work.

       

      IF ([ACCOUNTING WEEK #] >= 4 AND [YEAR] >= 2012 AND [SALES UNITS]<0) THEN  [SALES UNITS] END

       

      Any ideas?

        • 1. Re: Calculated Field with multiple criteria
          Dan Huff

          Jesse--

           

          One way you can check to see what is causing the issue is to build the calculation piece by piece. In other words, start with the following-- IF [ACCOUNTING WEEK #] >= 4 THEN [SALES UNITS] END -- and then, if that works, add in the next part IF [ACCOUNTING WEEK #] >= 4 AND [YEAR] >= 2012 THEN [SALES UNITS] END .

           

          If you still see issues, I would be happy to take a look at it if you could provide a sample dataset. Also, what is your underlying datasource if you don't mind me asking?

           

          Hope this helps,

           

          Dan