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

[#1]

• 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)

• 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))

    )

Could anyone please help me to solve this problem?

Thanks in advance

Message was edited by: gunenthiran b

[#2]

try suppress missing values

With Regards

Harshita Gaur

[#3]

Thank you for your reply.

But i tried suppress missing/null values also not working.

[#4]

hi,

can you attach your QVW? and your data sheet?

With regards

Harshita gaur

[#5]

Hi Harshita gaur,
I attached my qvw and data sheet in the question.
please find the attachment and please note that we are using QV10.
Thanks