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

[fmazzarelli]

Hi,

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

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

[sunny_talwar]

May be this:

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

[Chanty4u]

try below

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

[fmazzarelli]

Hi,

the formula has extract the values ​​<> null.

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

1

[gferran]

Fabio,

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

Regards

[Chanty4u]

try below

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

[fmazzarelli]

Hi,

unfortunately it does not work

[sunny_talwar]

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

[fmazzarelli]

thanks anyway, revenue for the value difference

[fmazzarelli]

Hi,

thanks anyway

1