5 Replies Latest reply: Mar 17, 2014 10:42 AM by Steve Dillon RSS

    Why does my expression return a zero value

    Steve Dillon

      I have an expression written as follows:

       

      fabs(sum({<ItemCategory={'Classbook Reprints'}>}ITEM_COUNT))/fabs(sum({<ItemCategory={'Classbook Original Manuscripts'}>}ITEM_COUNT))

       

      This returns a value of zero.

       

      However, when I break the two pieces out on their own, each returns a value. Why when I divide the sums against eachother, am I getting a zero?

       

      The first section returns a value of 130451. The 2nd section returns a value of 15583.

       

      The result I am trying to arrive at through my expression is 8.37.