Replace NaN and Error in one formula in Power Query

[Skip2MiLu]

Hi I am looking to replace both NaN and Error in one formula in Power Query

I thought that the following formula would work, but it looks like it only performs part of the formula. Pretty sure I wrote it incorrectly. Any support appreciated

try ([#"YTG (Amt)"]/[#"YTG (Qty)"]) otherwise Number.IsNaN ([#"YTG (Amt)"]/[#"YTG (Qty)"])

 

[jdellasala]

The PQ function Number.IsNaN stand for Not A Number and returns TRUE if the parameter provided is NOT a number, and FALSE if it is. What were you expecting?