T
tsison7
In a query I added another field with the equation: margin:[profit]/[price].
The problem is if the price is $0 (ie. free of charge) the query will not
run. I actually fixed this by adding a Max(0.00001, [profit]) into the
equation but there must be a better way.
The problem is if the price is $0 (ie. free of charge) the query will not
run. I actually fixed this by adding a Max(0.00001, [profit]) into the
equation but there must be a better way.