C Cele Member Jun 22, 2017 #1 Hi, How do I write this formula in M language? =IFERROR(H3/F3,0) Please advise. Thanks Cele
R r2c2 Active Member Jun 27, 2017 #2 @Cele I don't have PQ on this comp to test. But the general approach can be Use divide function if one is available. this should have a div/0 optional value. Else, Just divide column H with column F as a new calculated column Then replace errors with zero using replace errors transformation
@Cele I don't have PQ on this comp to test. But the general approach can be Use divide function if one is available. this should have a div/0 optional value. Else, Just divide column H with column F as a new calculated column Then replace errors with zero using replace errors transformation
N NARAYANK991 Excel Ninja Jun 27, 2017 #3 Hi , Google throws up the following informative results : http://radacad.com/make-your-numeric-division-faultless-in-power-query https://blog.gbrueckl.at/2013/12/error-handling-in-power-query/ There are many more , of course. Narayan
Hi , Google throws up the following informative results : http://radacad.com/make-your-numeric-division-faultless-in-power-query https://blog.gbrueckl.at/2013/12/error-handling-in-power-query/ There are many more , of course. Narayan
