Notifications
Clear all
Power Query
5
Posts
2
Users
0
Reactions
140
Views
Topic starter
Hi,
How do I write this formula in Power Query?
=IFERROR(H3/F3,0)
I want it to divide column H and F. And if these numbers are 0/0 i want the result to come back as 0. Not #NUM.
Please avised
Thank you
Cele
Posted : 23/06/2017 11:30 am
Hi Celeste,
Use:
try [Column1]/[Column2] otherwise 0
Posted : 23/06/2017 3:49 pm
Topic starter
I did try that, and when and it still comes up. And on the actual query it reads NaN
Posted : 23/06/2017 4:07 pm
Try an if conditon then, if you don't like the response types:
if [2]>0 then [1]/[2] else 0
Posted : 23/06/2017 4:33 pm
Topic starter
You are a SUPER STAR!!! it worked!!! YESS!!!!!!!
A million thanks!!!
Posted : 24/06/2017 5:21 am
