Statement Get's Error Message

MattReinders — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Statement Get's Error Message

Vegar — Fri, 29 Mar 2019 18:22:46 GMT

Try replacing your red expression with the following:

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

Re: Statement Get's Error Message

MattReinders — Fri, 29 Mar 2019 18:33:43 GMT

Solved it. Thank you

Re: Statement Get's Error Message

Claudiu_Anghelescu — Sat, 30 Mar 2019 22:48:20 GMT

Mark as Solved please!

topic Re: Statement Get's Error Message in QlikView

Statement Get's Error Message

Re: Statement Get's Error Message

Re: Statement Get's Error Message

Re: Statement Get's Error Message