if function

[somthingmendi123]

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

[Chanty4u · Accepted solution]

Try this may be

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

[somthingmendi123]

Thanks
It works