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 does not work).
Is there some combination of List.Sum and List.Transform to acheive this task?
Thanking in advance
See here
List.Sum(List.Transform({"x", "100","200", "x300", 500}, (x)=> if Value.FromText(x) is number then Value.FromText(x) else 0 ))
2 Replies
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.
