cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
isamchakur Occasional Visitor
Occasional Visitor

If Is number function

Hey guys,

 

I have a column with both text and numbers, and I need to perform a calculation only for the numbers. I have tough at

if (Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"PCE (ug/L)"]/165.83). Why that doesn't run?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: If Is number function

Hi @isamchakur,

 

You need to escape the special characters in the column name. Please try this one.

if Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"#""PCE (ug/L)"""]/165.83 else 0

If-Is-number-function

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: If Is number function

Hi @isamchakur,

 

You need to escape the special characters in the column name. Please try this one.

if Value.Is(Value.FromText([ColumnOfMixedValues]), type number) then [#"#""PCE (ug/L)"""]/165.83 else 0

If-Is-number-function

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.