Boolean contradiction in chart and data manager

[paul_scotchford]

Hi All,

This expression works in a Table,Chart etc but not in a calculated field via the data manager (Sept 2019 desktop release) 

[List Price] - if(IsNull([Discount Amount])=-1,0,[Discount Amount])

I had to remove the negative value when I was testing this in the Data Manager , see below , it works but is not what I expected to code in the expression based on convention ...

[List Price]-if(IsNull([Discount Amount])=1,0,[Discount Amount])

The error message returned by the data manager (Create Calculated Field) is "Missing right term"

Is this a bug or have I misinterpreted functionality?

[Yousef_Amarneh]

Try to use this 

[List Price]-if(IsNull([Discount Amount]),0,[Discount Amount])

OR

[List Price]-Alt([Discount Amount],0)