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.