Hello All,
I am trying to diagnose a very simple load for a colleague and am getting invalid expression. Could somebody please help?
The invalid expression is coming from what is highlighted in red.
LOAD
[PO Status],
[Ariba REQ #],
[PO Number],
[PO Create Date],
[PO Val USD],
[PO Invoice Val USD],
[Item Val Remaining USD],
IF(SUM(DISTINCT[Item Val Remaining USD]/[PO Val USD]*100)>=10,'YES') AS PerctRemaining,
[PO Val Local Cur],
[PO Invoice Val Local Cur],
[Item Val Remaining Local Cur],
[PO Local Cur],
[PO Val Doc Cur],
[PO Invoice Val Doc Cur],
[Item Val Remaining Doc Cur],
[PO Document Cur],
Preparer,
Requester,
[PO Cost Center],
[Business Partner],
[Cc Owner],
[Vendor Number],
[Vendor Name],
[PO Line Item Number],
[PO Item Description],
[GL Account Number],
[GL Acct Long Description],
[Ariba Requisition Title],
[Comp Code],
Function,
[Aprimo Activity Id]
FROM
[C:\Users\reindem\Desktop\Open PO Report.xlsx]
(ooxml, embedded labels, header is 1 lines, table is AMER);
Thank you,
Matt
