4 Replies Latest reply: Nov 24, 2014 7:06 AM by BGN bgn RSS

    Rangeavg() inside if(), unable to avoid null rows&columns

    BGN bgn
      • I tried the expression below and the result I got is show in the image(1) below.
                     =sum({<Type={'Inventory'}>} Units)

      Note: I'm using QV10

       

        image(1)

      image01.JPG.jpg

      • Thereafter I modified the expression with "rangeavg()" function. But I get additional null rows&columns (highlighted in the image below)
      • Also I tried suppress null values, but still I'm getting the same result.

       

      =if(sum({<Type={'Inventory'}>} Units),
          sum({<Type={'Inventory'}>} Units)/
          rangeavg(before(if(sum({<Type={'SalesOut'}>} Units)>=0,sum({<Type={'SalesOut'}>} Units)),0,8))
          )

      image02.JPG.jpg

      Could anyone please help me to solve this problem?

      Thanks in advance

       

      Message was edited by: gunenthiran b