Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See the included statement:
How can I exclude the result from below statement
if
(ACCOUNT='LB2675-92', 'DE VAT LB2675-92') as DE_VAT_in_MFL
into the below string of text
IF
(IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],
I tried already the following but it did not work:
IF(ACCOUNT<> 'LB2675-92' and IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],
IF(ISNULL(DE_VAT_in_MFL) and IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],
Your support is appreciated as I already lost a lott of time in this issue.
Regards,
Patrick
Hi Patrick,
I think you're going to have to explain your issue a bit better before we can offer any assistance. I (for one) have no idea what you're trying to do, or what the issue is.
For minispecifications i use booakmarks
For easy maintenance forall bookmarks i use particular tab, hide for end users
The each time to filter i execute bookmarks vía button or macro