Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Sum({<Commessa -= {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])
Note a small negative sign (in red) before the equal sign
Or this, if you don't want to be changed by selections in Commessa field:
Sum({<Commessa ={'*'} - {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])
Hi,
Try this will work, it will show as syntax error but it works
=sum({<Commessa = {'*'} - {'ASSCLI', 'ASSREM', 'ASSTEL', 'SPES16','QLIKVW'}>} [OreLavorateIncluse])
Regards,
Jagan.