How to put summation of not null values?

[#1]

Hi,

I want to put the summation of Cost in a text object, depends on the dimension, say for example Item,

but there are NULL item included in the summation, how to suppress null in text object.

Is this possible?

Thanks,

Bill

[#2]

try :

=sum({$<dimension={"*"}>}value)

[#3 · Accepted solution]

Hi Pari,

Thanks for sharing, I got this.

sum({<DIMENSION-= {$(null())} >} VALUE)

I put NEGATIVE sign before EQUAL sign.

Thanks.