2 Replies Latest reply on Apr 2, 2012 3:53 PM by Alex Kerin

    Calulated fields are multiplying my desired results to give false answers

      I am using the following forumla:

       

      IF(ITEMNMBR="X") THEN (3036-[Sales -  Initial Store Sets (Pre 11-7-2011)]) END

       

      I have one calculated field that is Titled "Sales -  Initial Store Sets (Pre MM-DD-YYYY)". 

       

      When I create the first calulated field it should give me a number around 3000, but for some reason its multiplying by something and giving me a number around 200,000. 

       

      Can someone offer insight into what may be happening here?  I assume it may be something with the first calculated field.