1-(ACOCMP1.CURRSALE.COST / ACOCMP1.CURRSALE.AMOUNT)
I am trying to calculate the margin using an sql view using the above statement.
When i do i get the error Divide by zero error encountered.
Any ideas how to get around this ?
I cannot change the table or data that the view looks at ?