9 Replies Latest reply: Sep 15, 2016 1:45 PM by fabio Mazzarelli

# sum({<Extracontabile = {' '}>} [ImportoSaldo])

Hi,

Sum if the value of the non-accounting field is null

sum({<Extracontabile = {' '}>} [ImportoSaldo]) but not workint

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

May be this:

Sum({<Extracontabile -= {'*'}>} [ImportoSaldo])

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

try below

sum({<Extracontabile -= {" *"}>} [ImportoSaldo])

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

Hi,

the formula has extract the values <> null.

Now I need to calculate, the values = null. Could you help me?

1

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

try below

sum({\$<Extracontabile ={"=len(trim(Extracontabile ))=0"}>} [ImportoSaldo])

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

Hi,

unfortunately it does not work

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

Is there a field which uniquely defines Extracontabile in your database?

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

thanks anyway, revenue for the value difference

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

Fabio,

you can find a  useful document at https://community.qlik.com/docs/DOC-4951

Regards

• ###### Re: sum({<Extracontabile = {' '}>} [ImportoSaldo])

Hi,

thanks anyway

1