Statement Get's Error Message

[MattReinders]

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

[Vegar]

Try replacing your red expression with the following:

IF(([Item Val Remaining USD]/[PO Val USD]*100)>=10,
'YES',
'NO') as PerctRemaining,

[MattReinders]

Solved it. Thank you 

[Claudiu_Anghelescu]

Mark as Solved please!