I am trying to do some basic calculation on a G Sheet and come up with some averages.
I have looked in the GSuite activities and didn’t see a match for doing calculations. The closest post I found is below with works with Studio X, which I don’t have.
Welcome to forums
Good that you have checked the Gsuite activites
currently there are no readymade activities to make the average, but you can use Read range activity of the Gsuite and copy that to a Datatable varaible now you can calculate the average of the column you required as below
@Srini84 Thank you for the pointers.
I understand the reading the range (column) and saving it into a variable.
What activity should I use to implement the formula you shared to calculate the average?