topic if function in App Development

if function

somthingmendi123 — Mon, 15 May 2023 13:44:54 GMT

In the if function, how can I condition that if there is a minus in a certain table then a minus will be displayed in another table. I am attaching a code I wrote but it does not give a good result. If(TotalPriceBeforVat < '0', Quantity = '-*' , Quantity) as CorrectedQuantity.

thenks

Re: if function

Chanty4u — Mon, 15 May 2023 14:40:11 GMT

Try this may be

IF(TotalPriceBeforVat < 0, '-' & Quantity, Quantity) AS CorrectedQuantity

Re: if function

somthingmendi123 — Mon, 15 May 2023 14:45:41 GMT

Thanks
It works