Create a new expression

[fmazzarelli]

Hi Community,

a simple question

I used this expression: to extract the value

sum({<Commessa = {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])

Now I need a new expression

sum({<Commessa <> {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])

I need to extract all data not included.

FabioM

[sunny_talwar]

Try this:

Sum({<Commessa -= {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])

Note a small negative sign (in red) before the equal sign

[sunny_talwar]

Or this, if you don't want to be changed by selections in Commessa field:

Sum({<Commessa ={'*'} - {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])

[jagan]

Hi,

Try this will work, it will show as syntax error but it works

=sum({<Commessa = {'*'} - {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])

Regards,

Jagan.