Malformed If statement

[AhanaR]

Could someone please tell me what I might be doing wrong here?

I'm trying to write an if statement to calculate price gain and is being prompted with an error as below :

Formula is :

IF [Document Currency]='USD' then(([Unit Price In Backlog]-[ASP (USD)])*[Backlog Quantity in Base Unit])elseif( ([Unit Price In Backlog]-[ASP (Local) ])*[Backlog Quantity in Base Unit])
ENDif

Dataset used :

Material	Unit Price In Backlog	Document Currency	ASP  (Local)	ASP (USD)	Backlog Quantity in Base Unit
ABC	600.00	USD	406.22	406.22	263
BYA	4,000.00	INR	3,467.13	3,467.13	4
SJR	120.00	USD	90.00	90.00	73
QVY	210.00	SGD	180.50	180.50	36

[ShankerV]

Hi @AhanaR 

The data type of the column might be in string.

Please convert to Integer type or Double and check.

[ShankerV · Accepted solution]

Hi @AhanaR 

Please find the sample use case.

IF [ Document Currency ]="USD"
Then(([Unit Price In Backlog]-[ ASP (USD) ])*[Backlog Quantity in Base Unit])
ELSE (([Unit Price In Backlog]-[ ASP (Local) ])*[Backlog Quantity in Base Unit])
ENDif

Many thanks

Shanker V

[AhanaR]

Thank You so much Shanker