Boolean contradiction in chart and data manager

paul_scotchford — Sat, 16 Nov 2024 19:42:05 GMT

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?

Re: Boolean contradiction in chart and data manager

Yousef_Amarneh — Mon, 11 Nov 2019 07:57:44 GMT

Try to use this

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

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

topic Re: Boolean contradiction in chart and data manager in App Development

Boolean contradiction in chart and data manager

Re: Boolean contradiction in chart and data manager