Forum Discussion
Solved
sum only numeric strings in a list containing both numeric and text strings
I am working with a list as follows : {"x", "100","200") And I want to sum only the 100 and 200, skipping the text string [the text string is not at a fixed loaction in all the lists, so list.skip ...
See here
List.Sum(List.Transform({"x", "100","200", "x300", 500}, (x)=> if Value.FromText(x) is number then Value.FromText(x) else 0 ))
See here
List.Sum(List.Transform({"x", "100","200", "x300", 500}, (x)=> if Value.FromText(x) is number then Value.FromText(x) else 0 ))
Thanks Vijay_A_Verma - that worked like a charm. I was missing using the function, which simplifies the code.