Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be
IF(TotalPriceBeforVat < 0, '-' & Quantity, Quantity) AS CorrectedQuantity
Try this may be
IF(TotalPriceBeforVat < 0, '-' & Quantity, Quantity) AS CorrectedQuantity
Thanks
It works