Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
hopefully this is a quick and easy one
i've got this expression
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department={'CAD','EAD'}>}amount
I would like the inverse of this NOT CAD and EAD I tried this (below) but it didn't work (and a few other attemps)
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department<>{'CAD','EAD'}>}amount
any help would be greatly appreciated
Thank you
Check this below one.
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'},Department-={'CAD','EAD'}>}amount)
EDIT:Working example of not equal to with set analysis is attached.
- Sridhar
Hi,
Why not just:
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}>} amount)
-
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department={'CAD','EAD'}>} amount)
/@Ungvall
Hi,
There are about 20 additional departments and i Didn't want to have
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department={'OTHER 20 DEPARTMENTS HERE'}>} amount)
I still would like the same G/L Account No's but just reflecting all the other departments CAD and EAD are slightly different, hence why I have separtated them
Thanks Torbjörn
Hi,
If it's that many I woould probably flag them in an Excel-file with 1 or 0. And then use
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Flag={'1'}>} amount) for example...
/@Ungvall
Check this below one.
sum({<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'},Department-={'CAD','EAD'}>}amount)
EDIT:Working example of not equal to with set analysis is attached.
- Sridhar
Hi,
Have you tried
sum({$<[G/L Account No]={'10130', '10045', '10040', '10020', '10110'}, Department-={'CAD','EAD'}>} amount)
(notice the minus sign efter "Department")
Perfect adding the Minus worked perfectly.
Thank very much for all your help
Frank Carlsson, Sridhar Ethiraj and Torbjörn Ungvall