Forum Discussion
Avoiding division by zero in Direct Query
I'm trying to connect to a database using direct query and creating a custom column where there is a division operation. How can I avoid division by zero if i cannot use the iferror function.
Using the divide function should allow you to put in the behaviour you want if you've got division by zero
I get an error "Expression.Error: The name 'divide' wasn't recognized. Make sure it's spelled correctly".