hey guys, I want to calculate the average of a column in a excel. row is a string and I have following functions that are giving me the error that can not convert to to null double.
(I have two different workflows doing the average on dfferent excels but is giving m same error although function is different):
the error:
thanks! will try
says “not convert object to string”, any idea how to solve this?
sorry, use this
outputMovie.AsEnumerable.Where(function(x) not String.isnullOrEmpty(x("movieRating").ToString)).AsEnumerable().Average(function(row) CDbl(row("movieRating")))
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
Soudios
ppr
Yoichi
lrtetala
Anjani_Kapoor
sarikayaebru
rodrigo.simao
Jon_Smith