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.