I have a simple formula that working great, but I want to replace any errors with blank.
Can anybody please help me to change this?
= Table.AddColumn(#"Added Custom", "AnnualBacklog", each if [AnnualThr] < [TotalRemaining] then [AnnualThr] else [TotalRemaining])
#"XYZ" = Table.AddColumn(#"Added Custom", "AnnualBacklog", each if [AnnualThr] < [TotalRemaining] then [AnnualThr] else [TotalRemaining])
#"Replaced Errors" = Table.ReplaceErrorValues(#"XYZ", {{"AnnualBacklog", ""}})
in
#"Replaced Errors"