Hi, I have the next excel sheet and I want to know how to get the sum of the 3 columns marked in yellow and write them in the row that says Total.
Thank you!
the work flow works but when I add it to my workflow I get this error
Hi,
This means there is non-numeric data (including empty).
For now, can you try to set the following expression at AddDataRow activity?
{"Total"}.Concat(Enumerable.Range(1,3).Select(Function(i) dt.AsEnumerable.Sum(Function(r) if(Double.TryParse( r(i).ToString,New Double), Double.Parse(r(i).ToString),0) ).ToString)).ToArray
Regards,
1 Like
Thank you very much, you helped me a lot!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.